home *** CD-ROM | disk | FTP | other *** search
/ BBS in a Box 15 / BBS in a box XV-1.iso / Files / Bus / H-L / Home Budget Templates.sit / Home Budget Template Series / BiWeekly Folder / BiWeekly Information < prev    next >
MacBinary  |  1994-10-09  |  44.3 KB  |  [TEXT/ttxt]

open in: MacOS 8.1     |     Win98     |     DOS

browse contents    |     view JSON data     |     view as text


This file was processed as: MacBinary (archive/macBinary).

ConfidenceProgramDetectionMatch TypeSupport
10% dexvert MacBinary (archive/macBinary) fallback Supported
1% dexvert Text File (text/txt) fallback Supported
100% file MacBinary II, inited, busy, Sun Oct 9 16:53:18 1994, modified Sun Oct 9 16:53:18 1994, creator SimpleText, type ASCII, 30881 bytes "BiWeekly Information" , at 0x7921 14100 bytes resource default (weak)
99% file data default
49% TrID Macintosh plain text (MacBinary) default
33% TrID raw Group 3 FAX bitmap default (weak)
16% TrID MacBinary 2 default (weak)
100% siegfried fmt/1762 MacBinary (II) default
100% lsar MacBinary default


id metadata
keyvalue
macFileType[TEXT]
macFileCreator[ttxt]



hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 14 42 69 57 65 65 6b | 6c 79 20 49 6e 66 6f 72 |..BiWeek|ly Infor|
|00000010| 6d 61 74 69 6f 6e 00 00 | 00 00 00 00 00 00 00 00 |mation..|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 54 45 58 54 74 74 78 | 74 05 00 00 00 00 00 00 |.TEXTttx|t.......|
|00000050| 00 00 00 00 00 78 a1 00 | 00 37 14 aa be 08 be aa |.....x..|.7......|
|00000060| be 08 be 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 ac 04 00 00 |........|........|
|00000080| 0d 09 09 09 09 09 09 09 | 09 09 09 09 42 49 57 45 |........|....BIWE|
|00000090| 45 4b 4c 59 20 48 4f 4d | 45 20 42 55 44 47 45 54 |EKLY HOM|E BUDGET|
|000000a0| 20 54 45 4d 50 4c 41 54 | 45 0d 09 09 09 09 09 09 | TEMPLAT|E.......|
|000000b0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000000c0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000000d0| 56 45 52 53 49 4f 4e 20 | 31 2e 30 0d 09 09 09 09 |VERSION |1.0.....|
|000000e0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|000000f0| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000100| 44 61 76 69 64 20 4d 2e | 20 48 75 67 68 65 73 0d |David M.| Hughes.|
|00000110| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000120| 09 09 09 09 09 09 09 09 | 09 09 09 09 09 09 09 09 |........|........|
|00000130| 09 09 09 09 09 09 a9 20 | 31 39 39 34 0d 0d 2d 2d |....... |1994..--|
|00000140| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000150| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000160| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000170| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000180| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000190| 2d 2d 2d 2d 2d 2d 2d 2d | 0d 20 20 20 20 20 20 20 |--------|. |
|000001a0| 54 68 69 73 20 70 72 6f | 64 75 63 74 20 77 61 73 |This pro|duct was|
|000001b0| 20 63 72 65 61 74 65 64 | 20 65 6e 74 69 72 65 6c | created| entirel|
|000001c0| 79 20 77 69 74 68 20 4d | 69 63 72 6f 73 6f 66 74 |y with M|icrosoft|
|000001d0| a8 20 45 78 63 65 6c 20 | 34 2e 30 20 26 20 4d 69 |. Excel |4.0 & Mi|
|000001e0| 63 72 6f 46 72 6f 6e 74 | 69 65 72 27 73 20 43 6f |croFront|ier's Co|
|000001f0| 6c 6f 72 20 49 74 21 aa | 20 32 2e 33 32 20 26 20 |lor It!.| 2.32 & |
|00000200| 33 2e 30 0d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |3.0.----|--------|
|00000210| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000220| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000230| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000240| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000250| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 0d 0d |--------|------..|
|00000260| 43 6f 6e 74 61 63 74 20 | 6d 65 20 74 68 72 6f 75 |Contact |me throu|
|00000270| 67 68 20 6f 6e 65 20 6f | 66 20 74 68 65 20 66 6f |gh one o|f the fo|
|00000280| 6c 6c 6f 77 69 6e 67 20 | 63 68 61 6e 6e 65 6c 73 |llowing |channels|
|00000290| 3a 0d 0d 41 4d 45 52 49 | 43 41 20 4f 4e 4c 49 4e |:..AMERI|CA ONLIN|
|000002a0| 45 3a 20 28 41 4f 4c 29 | 20 76 69 61 20 45 2d 6d |E: (AOL)| via E-m|
|000002b0| 61 69 6c 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ail | |
|000002c0| 20 44 41 56 49 44 45 4f | 35 34 30 0d 0d 54 45 4c | DAVIDEO|540..TEL|
|000002d0| 45 50 48 4f 4e 45 3a 20 | 20 20 20 20 20 20 20 20 |EPHONE: | |
|000002e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000002f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000300| 20 20 28 32 30 37 29 20 | 37 37 37 2d 35 33 31 32 | (207) |777-5312|
|00000310| 0d 0d 4d 41 49 4c 49 4e | 47 20 41 44 44 52 45 53 |..MAILIN|G ADDRES|
|00000320| 53 3a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |S: | |
|00000330| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000340| 20 20 44 41 56 49 44 20 | 4d 2e 20 48 55 47 48 45 | DAVID |M. HUGHE|
|00000350| 53 0d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |S. | |
|00000360| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000370| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000380| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 31 36 37 | | 167|
|00000390| 20 57 49 4e 54 45 52 20 | 53 54 2e 0d 20 20 20 20 | WINTER |ST.. |
|000003a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000003b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000003c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 41 | | A|
|000003d0| 55 42 55 52 4e 2c 20 4d | 41 49 4e 45 20 30 34 32 |UBURN, M|AINE 042|
|000003e0| 31 30 2d 35 31 38 38 0d | 2d 2d 2d 2d 2d 2d 2d 2d |10-5188.|--------|
|000003f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000400| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000410| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000420| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000430| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000440| 2d 2d 0d 0d 50 72 69 63 | 69 6e 67 20 61 6e 64 20 |--..Pric|ing and |
|00000450| 52 65 67 69 73 74 72 61 | 74 69 6f 6e 3a 0d 0d 49 |Registra|tion:..I|
|00000460| 20 68 61 76 65 20 64 65 | 63 69 64 65 64 20 74 6f | have de|cided to|
|00000470| 20 6d 61 6b 65 20 74 68 | 69 73 20 70 72 6f 64 75 | make th|is produ|
|00000480| 63 74 20 73 68 61 72 65 | 77 61 72 65 20 77 69 74 |ct share|ware wit|
|00000490| 68 20 61 6e 20 61 73 6b | 69 6e 67 20 70 72 69 63 |h an ask|ing pric|
|000004a0| 65 20 6f 66 20 24 31 35 | 2e 30 30 20 69 6e 20 55 |e of $15|.00 in U|
|000004b0| 2e 53 2e 20 66 75 6e 64 | 73 2e 20 20 50 61 79 6d |.S. fund|s. Paym|
|000004c0| 65 6e 74 20 63 61 6e 20 | 62 65 20 73 65 6e 74 20 |ent can |be sent |
|000004d0| 74 6f 20 74 68 65 20 61 | 62 6f 76 65 20 6d 61 69 |to the a|bove mai|
|000004e0| 6c 69 6e 67 20 61 64 64 | 72 65 73 73 2c 20 65 69 |ling add|ress, ei|
|000004f0| 74 68 65 72 20 62 79 20 | 63 68 65 63 6b 20 6f 72 |ther by |check or|
|00000500| 20 6d 6f 6e 65 79 20 6f | 72 64 65 72 20 2d 20 6e | money o|rder - n|
|00000510| 6f 20 63 61 73 68 20 70 | 6c 65 61 73 65 2c 20 61 |o cash p|lease, a|
|00000520| 73 20 74 68 61 74 20 6d | 61 79 20 68 61 76 65 20 |s that m|ay have |
|00000530| 61 20 74 65 6e 64 65 6e | 63 79 20 74 6f 20 64 69 |a tenden|cy to di|
|00000540| 73 61 70 70 65 61 72 20 | 69 6e 20 74 68 65 20 6d |sappear |in the m|
|00000550| 61 69 6c 2e 20 49 20 77 | 69 6c 6c 20 62 65 20 61 |ail. I w|ill be a|
|00000560| 76 61 69 6c 61 62 6c 65 | 20 74 68 72 6f 75 67 68 |vailable| through|
|00000570| 20 6f 6e 65 20 6f 66 20 | 74 68 65 20 61 62 6f 76 | one of |the abov|
|00000580| 65 20 6d 65 64 69 75 6d | 73 20 66 6f 72 20 67 75 |e medium|s for gu|
|00000590| 69 64 61 6e 63 65 20 61 | 73 20 6e 65 65 64 65 64 |idance a|s needed|
|000005a0| 2e 20 20 59 6f 75 20 77 | 69 6c 6c 20 6e 6f 74 69 |. You w|ill noti|
|000005b0| 63 65 20 74 68 61 74 20 | 74 68 69 73 20 70 72 69 |ce that |this pri|
|000005c0| 63 65 20 69 73 20 66 6f | 72 20 74 68 65 20 77 68 |ce is fo|r the wh|
|000005d0| 6f 6c 65 20 6b 69 74 20 | 61 6e 64 20 63 61 62 6f |ole kit |and cabo|
|000005e0| 6f 64 6c 65 2e 20 20 59 | 6f 75 20 77 69 6c 6c 20 |odle. Y|ou will |
|000005f0| 68 61 76 65 20 66 6f 75 | 72 20 64 69 66 66 65 72 |have fou|r differ|
|00000600| 65 6e 74 20 74 65 6d 70 | 6c 61 74 65 73 20 74 6f |ent temp|lates to|
|00000610| 20 63 68 6f 6f 73 65 20 | 66 72 6f 6d 2e 20 49 20 | choose |from. I |
|00000620| 6a 75 73 74 20 72 65 63 | 65 6e 74 6c 79 20 72 65 |just rec|ently re|
|00000630| 63 65 69 76 65 64 20 4d | 49 43 52 4f 53 4f 46 54 |ceived M|ICROSOFT|
|00000640| a8 20 45 58 43 45 4c 20 | 35 2e 30 2c 20 61 6e 64 |. EXCEL |5.0, and|
|00000650| 20 63 61 6e 27 74 20 77 | 61 69 74 20 74 6f 20 73 | can't w|ait to s|
|00000660| 65 65 20 77 68 61 74 20 | 49 20 77 69 6c 6c 20 62 |ee what |I will b|
|00000670| 65 20 61 62 6c 65 20 74 | 6f 20 64 6f 20 77 69 74 |e able t|o do wit|
|00000680| 68 20 69 74 20 4f 4e 20 | 54 48 45 53 45 20 54 45 |h it ON |THESE TE|
|00000690| 4d 50 4c 41 54 45 53 2e | 20 20 57 69 74 68 20 79 |MPLATES.| With y|
|000006a0| 6f 75 72 20 72 65 67 69 | 73 74 72 61 74 69 6f 6e |our regi|stration|
|000006b0| 2c 20 74 68 69 73 20 77 | 69 6c 6c 20 6b 65 65 70 |, this w|ill keep|
|000006c0| 20 79 6f 75 20 69 6e 20 | 74 68 65 20 6d 61 69 6e | you in |the main|
|000006d0| 73 74 72 65 61 6d 20 6f | 66 20 61 6e 79 20 75 70 |stream o|f any up|
|000006e0| 64 61 74 65 73 20 74 68 | 61 74 20 49 20 6d 61 79 |dates th|at I may|
|000006f0| 20 6f 66 66 65 72 2e 0d | 0d 57 68 65 6e 20 79 6f | offer..|.When yo|
|00000700| 75 20 72 65 67 69 73 74 | 65 72 2c 20 69 6e 63 6c |u regist|er, incl|
|00000710| 75 64 65 20 74 68 65 20 | 66 6f 6c 6c 6f 77 69 6e |ude the |followin|
|00000720| 67 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 3a 0d 0d |g inform|ation:..|
|00000730| 09 09 09 09 09 4e 41 4d | 45 2c 20 41 44 44 52 45 |.....NAM|E, ADDRE|
|00000740| 53 53 2c 20 54 45 4c 45 | 50 48 4f 4e 45 20 4e 55 |SS, TELE|PHONE NU|
|00000750| 4d 42 45 52 2c 20 41 4e | 44 20 4f 4e 2d 4c 49 4e |MBER, AN|D ON-LIN|
|00000760| 45 20 49 44 20 46 4f 52 | 20 43 4f 4e 54 41 43 54 |E ID FOR| CONTACT|
|00000770| 20 50 55 52 50 4f 53 45 | 53 0d 2d 2d 2d 2d 2d 2d | PURPOSE|S.------|
|00000780| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000790| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000007a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000007b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000007c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000007d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000007e0| 2d 2d 2d 2d 2d 2d 0d 0d | 50 65 72 6d 69 73 73 69 |------..|Permissi|
|000007f0| 6f 6e 73 20 61 6e 64 20 | 52 65 73 74 72 69 63 74 |ons and |Restrict|
|00000800| 69 6f 6e 73 3a 0d 0d 59 | 6f 75 20 6d 61 79 20 6d |ions:..Y|ou may m|
|00000810| 6f 64 69 66 79 20 74 68 | 69 73 20 54 45 4d 50 4c |odify th|is TEMPL|
|00000820| 41 54 45 20 61 6e 64 20 | 73 75 70 70 6f 72 74 69 |ATE and |supporti|
|00000830| 6e 67 20 70 72 6f 64 75 | 63 74 20 6d 6f 64 75 6c |ng produ|ct modul|
|00000840| 65 73 20 74 6f 20 73 75 | 69 74 20 79 6f 75 72 20 |es to su|it your |
|00000850| 69 6e 64 69 76 69 64 75 | 61 6c 20 6e 65 65 64 73 |individu|al needs|
|00000860| 2c 20 77 69 74 68 20 74 | 68 65 20 65 78 63 65 70 |, with t|he excep|
|00000870| 74 69 6f 6e 20 6f 66 20 | 6e 6f 74 20 64 69 73 74 |tion of |not dist|
|00000880| 72 69 62 75 74 69 6e 67 | 20 69 74 20 79 6f 75 72 |ributing| it your|
|00000890| 73 65 6c 66 20 74 6f 20 | 6f 74 68 65 72 73 20 66 |self to |others f|
|000008a0| 6f 72 20 69 6e 64 69 76 | 69 64 75 61 6c 20 70 72 |or indiv|idual pr|
|000008b0| 6f 66 69 74 20 62 79 20 | 79 6f 75 2e 20 59 6f 75 |ofit by |you. You|
|000008c0| 20 6d 61 79 20 61 6c 73 | 6f 20 64 69 73 74 72 69 | may als|o distri|
|000008d0| 62 75 74 65 20 74 68 69 | 73 20 70 72 6f 64 75 63 |bute thi|s produc|
|000008e0| 74 20 77 69 74 68 6f 75 | 74 20 72 65 73 65 72 76 |t withou|t reserv|
|000008f0| 61 74 69 6f 6e 73 2c 20 | 74 6f 20 61 6e 79 20 62 |ations, |to any b|
|00000900| 75 6c 6c 65 74 69 6e 20 | 62 6f 61 72 64 20 61 6e |ulletin |board an|
|00000910| 64 20 63 6f 6d 70 75 74 | 65 72 20 6f 6e 2d 6c 69 |d comput|er on-li|
|00000920| 6e 65 20 73 65 72 76 69 | 63 65 2e 20 49 6e 20 74 |ne servi|ce. In t|
|00000930| 68 61 74 20 72 65 67 61 | 72 64 2c 20 61 6c 6c 20 |hat rega|rd, all |
|00000940| 49 20 61 73 6b 20 69 73 | 20 61 20 6e 6f 74 69 66 |I ask is| a notif|
|00000950| 69 63 61 74 69 6f 6e 20 | 62 79 20 79 6f 75 20 28 |ication |by you (|
|00000960| 74 68 72 6f 75 67 68 20 | 6f 6e 65 20 6f 66 20 74 |through |one of t|
|00000970| 68 65 20 61 62 6f 76 65 | 20 63 68 61 6e 6e 65 6c |he above| channel|
|00000980| 73 29 20 6f 6e 20 77 68 | 65 72 65 20 69 74 20 77 |s) on wh|ere it w|
|00000990| 61 73 20 73 65 6e 74 2e | 20 54 68 69 73 20 70 72 |as sent.| This pr|
|000009a0| 6f 64 75 63 74 20 6d 61 | 79 20 6e 6f 74 20 62 65 |oduct ma|y not be|
|000009b0| 20 69 6e 63 6c 75 64 65 | 64 20 77 69 74 68 20 6f | include|d with o|
|000009c0| 74 68 65 72 20 70 72 6f | 64 75 63 74 73 20 74 68 |ther pro|ducts th|
|000009d0| 61 74 20 61 72 65 20 70 | 61 63 6b 61 67 65 64 20 |at are p|ackaged |
|000009e0| 61 6e 64 20 73 6f 6c 64 | 20 66 6f 72 20 70 72 6f |and sold| for pro|
|000009f0| 66 69 74 2c 20 75 6e 6c | 65 73 73 20 70 65 72 6d |fit, unl|ess perm|
|00000a00| 69 73 73 69 6f 6e 20 69 | 73 20 67 72 61 6e 74 65 |ission i|s grante|
|00000a10| 64 20 62 79 20 6d 65 2c | 20 74 68 65 20 61 75 74 |d by me,| the aut|
|00000a20| 68 6f 72 2e 0d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |hor..---|--------|
|00000a30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a50| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a70| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000a90| 2d 0d 0d 57 61 72 72 61 | 6e 74 79 3a 0d 0d 54 68 |-..Warra|nty:..Th|
|00000aa0| 65 20 61 62 6f 76 65 20 | 61 75 74 68 6f 72 2c 20 |e above |author, |
|00000ab0| 6d 61 6b 65 73 20 6e 6f | 20 70 72 6f 6d 69 73 65 |makes no| promise|
|00000ac0| 73 2c 20 65 69 74 68 65 | 72 20 65 78 70 72 65 73 |s, eithe|r expres|
|00000ad0| 73 65 64 20 6f 72 20 69 | 6d 70 6c 69 65 64 2c 20 |sed or i|mplied, |
|00000ae0| 66 6f 72 20 64 61 74 61 | 20 6c 6f 73 73 65 73 2e |for data| losses.|
|00000af0| 20 49 20 77 69 6c 6c 20 | 73 74 61 74 65 20 74 68 | I will |state th|
|00000b00| 61 74 20 73 61 66 65 20 | 70 72 61 63 74 69 63 65 |at safe |practice|
|00000b10| 73 20 6f 66 20 64 61 74 | 61 20 62 61 63 6b 75 70 |s of dat|a backup|
|00000b20| 20 77 69 6c 6c 20 73 61 | 66 65 67 75 61 72 64 20 | will sa|feguard |
|00000b30| 61 67 61 69 6e 73 74 20 | 73 75 63 68 20 6c 6f 73 |against |such los|
|00000b40| 73 65 73 2e 20 49 6e 20 | 6f 74 68 65 72 20 77 6f |ses. In |other wo|
|00000b50| 72 64 73 2c 20 61 6c 77 | 61 79 73 20 68 61 76 65 |rds, alw|ays have|
|00000b60| 20 79 6f 75 72 20 64 61 | 74 61 20 73 74 6f 72 65 | your da|ta store|
|00000b70| 64 20 73 61 66 65 6c 79 | 20 6f 6e 20 73 6f 6d 65 |d safely| on some|
|00000b80| 20 6d 65 64 69 75 6d 2c | 20 61 6e 64 20 74 68 65 | medium,| and the|
|00000b90| 6e 20 75 73 65 20 61 20 | 63 6f 70 79 20 6f 66 20 |n use a |copy of |
|00000ba0| 74 68 61 74 2c 20 61 6e | 64 20 74 68 65 6e 20 73 |that, an|d then s|
|00000bb0| 61 76 65 20 74 68 61 74 | 20 73 61 69 64 20 64 61 |ave that| said da|
|00000bc0| 74 61 2c 20 61 66 74 65 | 72 20 79 6f 75 20 68 61 |ta, afte|r you ha|
|00000bd0| 76 65 20 76 65 72 69 66 | 69 65 64 20 69 74 73 27 |ve verif|ied its'|
|00000be0| 20 76 61 6c 69 64 69 74 | 79 2e 20 54 68 65 73 65 | validit|y. These|
|00000bf0| 20 70 72 6f 64 75 63 74 | 73 20 73 68 6f 75 6c 64 | product|s should|
|00000c00| 20 62 65 20 75 73 65 64 | 20 61 74 20 79 6f 75 72 | be used| at your|
|00000c10| 20 6f 77 6e 20 72 69 73 | 6b 20 61 6e 64 20 64 69 | own ris|k and di|
|00000c20| 73 63 72 65 74 69 6f 6e | 2c 20 77 69 74 68 6f 75 |scretion|, withou|
|00000c30| 74 20 77 61 72 72 61 6e | 74 79 20 6f 66 20 61 6e |t warran|ty of an|
|00000c40| 79 20 6b 69 6e 64 2e 20 | 20 4e 65 69 74 68 65 72 |y kind. | Neither|
|00000c50| 20 6d 65 2c 20 6e 6f 72 | 20 61 6e 79 20 70 65 72 | me, nor| any per|
|00000c60| 73 6f 6e 20 6f 72 20 6f | 72 67 61 6e 69 7a 61 74 |son or o|rganizat|
|00000c70| 69 6f 6e 2c 20 74 68 61 | 74 20 73 75 70 70 6c 69 |ion, tha|t suppli|
|00000c80| 65 73 20 74 68 69 73 20 | 70 72 6f 64 75 63 74 2c |es this |product,|
|00000c90| 20 73 68 61 6c 6c 20 62 | 65 20 6c 69 61 62 6c 65 | shall b|e liable|
|00000ca0| 20 66 6f 72 20 64 61 6d | 61 67 65 73 20 74 68 61 | for dam|ages tha|
|00000cb0| 74 20 61 72 69 73 65 20 | 64 75 65 20 74 6f 20 75 |t arise |due to u|
|00000cc0| 73 65 20 6f 72 20 6d 69 | 73 75 73 65 2e 0d 2d 2d |se or mi|suse..--|
|00000cd0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000ce0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000cf0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000d00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000d10| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000d20| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000d30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 0d 0d 59 6f 75 72 |--------|--..Your|
|00000d40| 20 42 69 57 65 65 6b 6c | 79 20 46 6f 6c 64 65 72 | BiWeekl|y Folder|
|00000d50| 20 43 6f 6e 74 65 6e 74 | 73 3a 20 28 73 69 7a 65 | Content|s: (size|
|00000d60| 20 39 38 32 6b 29 0d 0d | 09 31 2e 20 42 69 57 65 | 982k)..|.1. BiWe|
|00000d70| 65 6b 6c 79 20 49 6e 66 | 6f 72 6d 61 74 69 6f 6e |ekly Inf|ormation|
|00000d80| 20 2d 20 73 69 6d 70 6c | 65 20 74 65 78 74 20 64 | - simpl|e text d|
|00000d90| 6f 63 75 6d 65 6e 74 20 | 74 68 61 74 20 79 6f 75 |ocument |that you|
|00000da0| 20 61 72 65 20 6e 6f 77 | 20 72 65 61 64 69 6e 67 | are now| reading|
|00000db0| 0d 0d 09 32 2e 20 42 69 | 57 65 65 6b 6c 79 20 32 |...2. Bi|Weekly 2|
|00000dc0| 36 2f 32 37 20 42 75 64 | 67 65 74 20 54 65 6d 70 |6/27 Bud|get Temp|
|00000dd0| 6c 61 74 65 20 28 77 68 | 69 63 68 20 69 6e 63 6c |late (wh|ich incl|
|00000de0| 75 64 65 73 20 34 35 30 | 20 64 65 66 69 6e 65 64 |udes 450| defined|
|00000df0| 20 6e 61 6d 65 73 29 20 | 0d 20 20 20 20 20 20 20 | names) |. |
|00000e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000e10| 20 20 20 20 20 20 49 6e | 69 74 69 61 6c 20 73 74 | In|itial st|
|00000e20| 61 72 74 69 6e 67 20 73 | 69 7a 65 20 2d 20 36 36 |arting s|ize - 66|
|00000e30| 32 6b 0d 09 33 2e 20 42 | 69 57 65 65 6b 6c 79 20 |2k..3. B|iWeekly |
|00000e40| 57 6f 72 6b 62 6f 6f 6b | 20 28 70 61 63 6b 65 64 |Workbook| (packed|
|00000e50| 20 77 2f 75 73 65 66 75 | 6c 20 77 6f 72 6b 73 68 | w/usefu|l worksh|
|00000e60| 65 65 74 73 29 0d 20 20 | 20 20 20 20 20 20 20 20 |eets). | |
|00000e70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000e80| 20 20 20 49 6e 69 74 69 | 61 6c 20 73 74 61 72 74 | Initi|al start|
|00000e90| 69 6e 67 20 73 69 7a 65 | 20 2d 20 32 37 34 6b 0d |ing size| - 274k.|
|00000ea0| 09 34 2e 20 41 6e 20 49 | 63 6f 6e 20 53 74 6f 72 |.4. An I|con Stor|
|00000eb0| 61 67 65 20 66 6f 6c 64 | 65 72 20 74 68 61 74 20 |age fold|er that |
|00000ec0| 68 6f 75 73 65 73 20 72 | 65 6c 61 74 65 64 20 69 |houses r|elated i|
|00000ed0| 63 6f 6e 73 0d 0d 09 35 | 2e 20 59 65 74 20 74 6f |cons...5|. Yet to|
|00000ee0| 20 62 65 20 67 65 6e 65 | 72 61 74 65 64 20 66 72 | be gene|rated fr|
|00000ef0| 6f 6d 20 74 68 65 20 61 | 62 6f 76 65 20 54 65 6d |om the a|bove Tem|
|00000f00| 70 6c 61 74 65 20 2d 20 | 27 4e 65 77 20 57 6f 72 |plate - |'New Wor|
|00000f10| 6b 73 68 65 65 74 27 0d | 0d 20 20 20 20 20 20 20 |ksheet'.|. |
|00000f20| 20 20 20 20 20 20 20 20 | 20 20 5b 4d 45 4d 4f 52 | | [MEMOR|
|00000f30| 59 20 52 45 51 55 49 52 | 45 4d 45 4e 54 53 3a 20 |Y REQUIR|EMENTS: |
|00000f40| 49 20 48 41 56 45 20 4d | 49 43 52 4f 53 4f 46 54 |I HAVE M|ICROSOFT|
|00000f50| a8 20 45 58 43 45 4c 20 | 53 45 54 20 54 4f 20 33 |. EXCEL |SET TO 3|
|00000f60| 30 30 30 4b 5d 0d 0d 54 | 68 65 20 42 69 57 65 65 |000K]..T|he BiWee|
|00000f70| 6b 6c 79 20 32 36 2f 32 | 37 20 42 75 64 67 65 74 |kly 26/2|7 Budget|
|00000f80| 20 54 65 6d 70 6c 61 74 | 65 20 68 61 73 20 62 65 | Templat|e has be|
|00000f90| 65 6e 20 73 75 63 63 65 | 73 73 66 75 6c 6c 79 20 |en succe|ssfully |
|00000fa0| 74 65 73 74 65 64 20 77 | 69 74 68 20 6c 69 76 65 |tested w|ith live|
|00000fb0| 20 64 61 74 61 2e 20 20 | 46 72 6f 6d 20 74 68 65 | data. |From the|
|00000fc0| 20 74 65 6d 70 6c 61 74 | 65 20 61 20 6e 65 77 20 | templat|e a new |
|00000fd0| 77 6f 72 6b 73 68 65 65 | 74 20 69 73 20 67 65 6e |workshee|t is gen|
|00000fe0| 65 72 61 74 65 64 20 66 | 6f 72 20 79 6f 75 20 74 |erated f|or you t|
|00000ff0| 6f 20 75 73 65 20 61 6e | 64 20 61 64 61 70 74 20 |o use an|d adapt |
|00001000| 74 6f 20 66 69 74 20 79 | 6f 75 72 20 6e 65 65 64 |to fit y|our need|
|00001010| 73 2e 20 20 53 6f 6d 65 | 20 6f 66 20 74 68 65 20 |s. Some| of the |
|00001020| 74 69 74 6c 65 73 20 6d | 61 79 20 62 65 20 69 6e |titles m|ay be in|
|00001030| 61 70 70 72 6f 70 72 69 | 61 74 65 20 66 6f 72 20 |appropri|ate for |
|00001040| 79 6f 75 2c 20 20 73 6f | 20 6a 75 73 74 20 63 68 |you, so| just ch|
|00001050| 61 6e 67 65 20 74 68 65 | 6d 21 21 20 49 66 20 79 |ange the|m!! If y|
|00001060| 6f 75 20 77 69 73 68 20 | 74 6f 20 20 6d 61 6b 65 |ou wish |to make|
|00001070| 20 70 65 72 6d 61 6e 65 | 6e 74 20 63 68 61 6e 67 | permane|nt chang|
|00001080| 65 73 20 74 6f 20 74 68 | 65 20 61 63 74 75 61 6c |es to th|e actual|
|00001090| 20 74 65 6d 70 6c 61 74 | 65 2c 20 69 74 20 77 6f | templat|e, it wo|
|000010a0| 75 6c 64 20 62 65 20 77 | 69 73 65 20 74 6f 20 77 |uld be w|ise to w|
|000010b0| 6f 72 6b 20 6f 6e 20 61 | 20 63 6f 70 79 20 66 69 |ork on a| copy fi|
|000010c0| 72 73 74 2c 20 75 6e 74 | 69 6c 20 79 6f 75 20 68 |rst, unt|il you h|
|000010d0| 61 76 65 20 61 64 61 70 | 74 65 64 20 74 68 65 20 |ave adap|ted the |
|000010e0| 74 65 6d 70 6c 61 74 65 | 20 74 6f 20 66 69 74 20 |template| to fit |
|000010f0| 79 6f 75 72 20 6e 65 65 | 64 73 2e 20 46 72 6f 6d |your nee|ds. From|
|00001100| 20 6d 79 20 6f 77 6e 20 | 73 74 61 6e 64 70 6f 69 | my own |standpoi|
|00001110| 6e 74 2c 20 49 20 68 61 | 76 65 20 66 6f 75 6e 64 |nt, I ha|ve found|
|00001120| 20 74 68 61 74 20 75 6e | 6c 65 73 73 20 74 68 65 | that un|less the|
|00001130| 72 65 20 61 72 65 20 6d | 61 6a 6f 72 20 63 68 61 |re are m|ajor cha|
|00001140| 6e 67 65 73 20 6e 65 65 | 64 65 64 2c 20 61 6c 74 |nges nee|ded, alt|
|00001150| 65 72 69 6e 67 20 74 68 | 65 20 73 70 65 63 69 66 |ering th|e specif|
|00001160| 69 63 20 73 70 72 65 61 | 64 73 68 65 65 74 20 69 |ic sprea|dsheet i|
|00001170| 73 20 73 75 66 66 69 63 | 69 65 6e 74 20 65 6e 6f |s suffic|ient eno|
|00001180| 75 67 68 2e 20 0d 0d 54 | 68 65 20 42 69 57 65 65 |ugh. ..T|he BiWee|
|00001190| 6b 6c 79 20 57 6f 72 6b | 62 6f 6f 6b 20 69 73 20 |kly Work|book is |
|000011a0| 6c 6f 61 64 65 64 20 77 | 69 74 68 20 67 6f 6f 64 |loaded w|ith good|
|000011b0| 69 65 73 2e 20 20 45 61 | 63 68 20 66 69 6c 65 20 |ies. Ea|ch file |
|000011c0| 28 61 63 74 75 61 6c 6c | 79 20 77 6f 72 6b 73 68 |(actuall|y worksh|
|000011d0| 65 65 74 29 20 69 6e 20 | 74 68 65 20 77 6f 72 6b |eet) in |the work|
|000011e0| 62 6f 6f 6b 20 77 61 73 | 20 63 72 65 61 74 65 64 |book was| created|
|000011f0| 20 77 69 74 68 20 72 65 | 6c 61 74 69 6f 6e 73 68 | with re|lationsh|
|00001200| 69 70 73 20 69 6e 20 6d | 69 6e 64 20 74 6f 20 74 |ips in m|ind to t|
|00001210| 68 65 20 63 61 74 65 67 | 6f 72 69 65 73 20 6f 6e |he categ|ories on|
|00001220| 20 74 68 65 20 74 65 6d | 70 6c 61 74 65 2e 20 41 | the tem|plate. A|
|00001230| 73 20 79 6f 75 20 73 74 | 61 72 74 20 61 20 6e 65 |s you st|art a ne|
|00001240| 77 20 77 6f 72 6b 73 68 | 65 65 74 20 66 72 6f 6d |w worksh|eet from|
|00001250| 20 74 68 65 20 74 65 6d | 70 6c 61 74 65 2c 20 61 | the tem|plate, a|
|00001260| 6e 64 2f 6f 72 20 64 65 | 6c 65 74 65 2f 61 64 64 |nd/or de|lete/add|
|00001270| 20 72 6f 77 28 73 29 20 | 61 73 20 72 65 71 75 69 | row(s) |as requi|
|00001280| 72 65 64 2c 20 74 68 65 | 6e 20 79 6f 75 20 63 61 |red, the|n you ca|
|00001290| 6e 20 63 72 65 61 74 65 | 20 6c 69 6e 6b 73 20 74 |n create| links t|
|000012a0| 6f 20 74 68 69 73 20 6e | 65 77 20 77 6f 72 6b 73 |o this n|ew works|
|000012b0| 68 65 65 74 2e 20 54 68 | 65 20 42 69 57 65 65 6b |heet. Th|e BiWeek|
|000012c0| 6c 79 20 57 6f 72 6b 62 | 6f 6f 6b 20 67 69 76 65 |ly Workb|ook give|
|000012d0| 73 20 64 69 72 65 63 74 | 69 6f 6e 73 20 69 6e 20 |s direct|ions in |
|000012e0| 79 65 6c 6c 6f 77 20 6f | 6e 20 77 68 65 72 65 20 |yellow o|n where |
|000012f0| 74 6f 20 6c 6f 63 61 74 | 65 20 74 68 65 20 63 6f |to locat|e the co|
|00001300| 6e 6e 65 63 74 69 6f 6e | 73 20 66 6f 72 20 6c 69 |nnection|s for li|
|00001310| 6e 6b 69 6e 67 2e 20 54 | 68 65 20 66 6f 6c 6c 6f |nking. T|he follo|
|00001320| 77 69 6e 67 20 77 6f 72 | 6b 73 68 65 65 74 73 20 |wing wor|ksheets |
|00001330| 61 72 65 20 73 74 6f 72 | 65 64 20 69 6e 20 74 68 |are stor|ed in th|
|00001340| 65 20 6f 72 64 65 72 20 | 73 68 6f 77 6e 20 69 6e |e order |shown in|
|00001350| 20 74 68 65 20 42 69 57 | 65 65 6b 6c 79 20 57 6f | the BiW|eekly Wo|
|00001360| 72 6b 62 6f 6f 6b 3a 0d | 0d 52 45 4d 49 4e 44 45 |rkbook:.|.REMINDE|
|00001370| 52 3a 20 54 48 45 20 4e | 45 57 20 57 4f 52 4b 53 |R: THE N|EW WORKS|
|00001380| 48 45 45 54 20 48 41 53 | 4e 27 54 20 42 45 45 4e |HEET HAS|N'T BEEN|
|00001390| 20 4c 49 4e 4b 45 44 20 | 59 45 54 2c 20 42 45 43 | LINKED |YET, BEC|
|000013a0| 41 55 53 45 20 59 4f 55 | 20 4d 55 53 54 20 46 49 |AUSE YOU| MUST FI|
|000013b0| 52 53 54 20 43 52 45 41 | 54 45 20 49 54 20 46 52 |RST CREA|TE IT FR|
|000013c0| 4f 4d 20 54 48 45 20 42 | 49 57 45 45 4b 4c 59 20 |OM THE B|IWEEKLY |
|000013d0| 32 36 2f 32 37 20 42 55 | 44 47 45 54 20 54 45 4d |26/27 BU|DGET TEM|
|000013e0| 50 4c 41 54 45 20 41 42 | 4f 56 45 2e 20 4f 50 45 |PLATE AB|OVE. OPE|
|000013f0| 4e 49 4e 47 20 49 54 20 | 57 49 4c 4c 20 44 4f 20 |NING IT |WILL DO |
|00001400| 54 48 41 54 21 21 0d 0d | 31 2e 20 41 4e 59 57 48 |THAT!!..|1. ANYWH|
|00001410| 45 52 45 2c 20 55 53 41 | 20 54 52 49 50 20 2d 20 |ERE, USA| TRIP - |
|00001420| 54 68 69 73 20 77 6f 72 | 6b 73 68 65 65 74 20 68 |This wor|ksheet h|
|00001430| 61 73 20 62 65 65 6e 20 | 69 6e 76 61 6c 75 61 62 |as been |invaluab|
|00001440| 6c 65 20 61 73 20 61 6e | 20 61 69 64 20 66 6f 72 |le as an| aid for|
|00001450| 20 76 61 63 61 74 69 6f | 6e 20 70 6c 61 6e 6e 69 | vacatio|n planni|
|00001460| 6e 67 2e 20 59 6f 75 20 | 77 69 6c 6c 20 6e 6f 74 |ng. You |will not|
|00001470| 69 63 65 20 74 68 61 74 | 20 49 20 68 61 76 65 20 |ice that| I have |
|00001480| 6c 69 6e 6b 65 64 20 74 | 68 65 20 4d 41 53 54 45 |linked t|he MASTE|
|00001490| 52 43 41 52 44 20 61 6e | 64 20 56 49 53 41 20 77 |RCARD an|d VISA w|
|000014a0| 6f 72 6b 73 68 65 65 74 | 73 20 74 6f 20 64 72 61 |orksheet|s to dra|
|000014b0| 77 20 75 70 6f 6e 2f 66 | 72 6f 6d 20 69 66 20 6e |w upon/f|rom if n|
|000014c0| 65 65 64 65 64 2e 20 54 | 68 65 20 70 6f 73 73 69 |eeded. T|he possi|
|000014d0| 62 69 6c 69 74 69 65 73 | 20 61 72 65 20 65 6e 64 |bilities| are end|
|000014e0| 6c 65 73 73 2c 20 61 6e | 64 20 62 61 73 69 63 61 |less, an|d basica|
|000014f0| 6c 6c 79 20 75 70 20 74 | 6f 20 79 6f 75 72 20 64 |lly up t|o your d|
|00001500| 69 73 63 72 65 74 69 6f | 6e 2e 0d 32 2e 20 54 41 |iscretio|n..2. TA|
|00001510| 58 45 53 20 49 52 53 20 | 41 4e 44 20 53 54 41 54 |XES IRS |AND STAT|
|00001520| 45 20 2d 20 57 69 74 68 | 20 74 68 65 20 49 52 53 |E - With| the IRS|
|00001530| 20 72 65 71 75 69 72 65 | 6d 65 6e 74 20 66 6f 72 | require|ment for|
|00001540| 20 77 69 74 68 68 6f 6c | 64 69 6e 67 20 61 74 20 | withhol|ding at |
|00001550| 6c 65 61 73 74 20 39 30 | 25 20 6f 66 20 79 6f 75 |least 90|% of you|
|00001560| 72 20 74 61 78 20 6c 69 | 61 62 69 6c 69 74 79 2c |r tax li|ability,|
|00001570| 20 77 65 20 68 61 76 65 | 20 62 65 65 6e 20 70 72 | we have| been pr|
|00001580| 6f 6a 65 63 74 69 6e 67 | 20 6f 75 72 20 74 61 78 |ojecting| our tax|
|00001590| 20 6e 65 65 64 73 20 66 | 6f 72 20 74 68 65 20 49 | needs f|or the I|
|000015a0| 52 53 20 61 6e 64 20 6f | 75 72 20 68 6f 6d 65 20 |RS and o|ur home |
|000015b0| 73 74 61 74 65 2e 20 20 | 42 79 20 70 72 6f 6a 65 |state. |By proje|
|000015c0| 63 74 69 6e 67 20 61 68 | 65 61 64 2c 20 79 6f 75 |cting ah|ead, you|
|000015d0| 20 63 61 6e 20 75 73 65 | 20 74 68 69 73 20 77 6f | can use| this wo|
|000015e0| 72 6b 73 68 65 65 74 20 | 74 6f 20 68 65 6c 70 20 |rksheet |to help |
|000015f0| 79 6f 75 20 6d 65 65 74 | 20 79 6f 75 72 20 6d 69 |you meet| your mi|
|00001600| 6e 69 6d 75 6d 20 6e 65 | 65 64 73 2c 20 61 6e 64 |nimum ne|eds, and|
|00001610| 20 65 69 74 68 65 72 20 | 69 6e 63 72 65 61 73 65 | either |increase|
|00001620| 20 6f 72 20 64 65 63 72 | 65 61 73 65 20 74 68 65 | or decr|ease the|
|00001630| 20 49 52 53 20 6f 72 20 | 53 74 61 74 65 20 74 61 | IRS or |State ta|
|00001640| 78 20 64 65 64 75 63 74 | 69 6f 6e 20 66 72 6f 6d |x deduct|ion from|
|00001650| 20 79 6f 75 72 20 70 61 | 79 63 68 65 63 6b 28 73 | your pa|ycheck(s|
|00001660| 29 2e 0d 33 2e 20 4d 41 | 4a 4f 52 20 4d 45 44 49 |)..3. MA|JOR MEDI|
|00001670| 43 41 4c 20 45 58 50 45 | 4e 53 45 53 20 2d 20 54 |CAL EXPE|NSES - T|
|00001680| 68 69 73 20 77 6f 72 6b | 73 68 65 65 74 20 77 61 |his work|sheet wa|
|00001690| 73 20 66 6f 73 74 65 72 | 65 64 20 72 65 61 6c 69 |s foster|ed reali|
|000016a0| 7a 69 6e 67 20 74 68 61 | 74 20 61 6e 79 20 70 65 |zing tha|t any pe|
|000016b0| 72 73 6f 6e 28 73 29 20 | 63 61 6e 20 65 78 70 65 |rson(s) |can expe|
|000016c0| 72 69 65 6e 63 65 20 6d | 61 6a 6f 72 20 6d 65 64 |rience m|ajor med|
|000016d0| 69 63 61 6c 20 65 76 65 | 6e 74 73 20 74 68 61 74 |ical eve|nts that|
|000016e0| 20 72 65 71 75 69 72 65 | 20 61 20 70 61 79 6d 65 | require| a payme|
|000016f0| 6e 74 20 73 63 68 65 64 | 75 6c 65 2e 20 48 6f 70 |nt sched|ule. Hop|
|00001700| 65 66 75 6c 6c 79 20 74 | 68 69 73 20 77 69 6c 6c |efully t|his will|
|00001710| 20 68 65 6c 70 20 79 6f | 75 20 6b 65 65 70 20 6f | help yo|u keep o|
|00001720| 6e 20 74 72 61 63 6b 2e | 20 0d 0d 54 68 65 20 66 |n track.| ..The f|
|00001730| 6f 6c 6c 6f 77 69 6e 67 | 20 77 6f 72 6b 73 68 65 |ollowing| workshe|
|00001740| 65 74 73 20 77 65 72 65 | 20 6e 61 6d 65 64 20 74 |ets were| named t|
|00001750| 6f 20 70 61 72 61 6c 6c | 65 6c 20 61 20 63 61 74 |o parall|el a cat|
|00001760| 65 67 6f 72 79 20 6e 61 | 6d 65 20 6f 6e 20 74 68 |egory na|me on th|
|00001770| 65 20 42 69 57 65 65 6b | 6c 79 20 32 36 2f 32 37 |e BiWeek|ly 26/27|
|00001780| 20 42 75 64 67 65 74 20 | 54 65 6d 70 6c 61 74 65 | Budget |Template|
|00001790| 2e 20 20 49 66 20 74 68 | 69 73 20 6e 61 6d 65 20 |. If th|is name |
|000017a0| 64 6f 65 73 20 6e 6f 74 | 20 66 69 74 20 79 6f 75 |does not| fit you|
|000017b0| 72 20 6e 65 65 64 73 2c | 20 74 68 65 6e 20 62 79 |r needs,| then by|
|000017c0| 20 61 6c 6c 20 6d 65 61 | 6e 73 2c 20 63 68 61 6e | all mea|ns, chan|
|000017d0| 67 65 20 74 68 65 20 6e | 61 6d 65 20 6f 66 20 65 |ge the n|ame of e|
|000017e0| 61 63 68 20 77 6f 72 6b | 73 68 65 65 74 20 74 6f |ach work|sheet to|
|000017f0| 20 74 68 65 20 61 70 70 | 72 6f 70 72 69 61 74 65 | the app|ropriate|
|00001800| 20 6e 61 6d 65 2e 20 20 | 4d 61 6b 65 20 73 75 72 | name. |Make sur|
|00001810| 65 20 79 6f 75 20 74 68 | 65 6e 20 6c 69 6e 6b 20 |e you th|en link |
|00001820| 74 68 69 73 20 77 6f 72 | 6b 62 6f 6f 6b 20 77 6f |this wor|kbook wo|
|00001830| 72 6b 73 68 65 65 74 20 | 74 6f 20 74 68 65 20 63 |rksheet |to the c|
|00001840| 6f 72 72 65 73 70 6f 6e | 64 69 6e 67 20 63 61 74 |orrespon|ding cat|
|00001850| 65 67 6f 72 79 20 61 63 | 63 6f 75 6e 74 20 6f 6e |egory ac|count on|
|00001860| 20 74 68 65 20 4e 45 57 | 20 57 4f 52 4b 53 48 45 | the NEW| WORKSHE|
|00001870| 45 54 20 79 6f 75 20 63 | 72 65 61 74 65 2e 20 49 |ET you c|reate. I|
|00001880| 20 63 61 6e 20 70 72 65 | 74 74 79 20 6d 75 63 68 | can pre|tty much|
|00001890| 20 64 65 74 65 72 6d 69 | 6e 65 20 77 68 65 6e 20 | determi|ne when |
|000018a0| 49 20 77 69 6c 6c 20 70 | 61 79 20 6f 66 66 20 6f |I will p|ay off o|
|000018b0| 6e 65 20 6f 66 20 74 68 | 65 73 65 20 63 72 65 64 |ne of th|ese cred|
|000018c0| 69 74 20 61 63 63 6f 75 | 6e 74 73 20 6a 75 73 74 |it accou|nts just|
|000018d0| 20 62 79 20 6c 69 6e 6b | 69 6e 67 20 74 68 65 20 | by link|ing the |
|000018e0| 70 61 79 6d 65 6e 74 73 | 2c 20 65 6e 74 65 72 69 |payments|, enteri|
|000018f0| 6e 67 20 74 68 65 20 70 | 75 72 63 68 61 73 65 73 |ng the p|urchases|
|00001900| 2c 20 61 6e 64 20 74 68 | 65 20 63 6f 72 72 65 63 |, and th|e correc|
|00001910| 74 20 66 69 6e 61 6e 63 | 65 20 72 61 74 65 73 2e |t financ|e rates.|
|00001920| 20 20 54 68 65 72 65 20 | 69 73 20 61 6c 73 6f 20 | There |is also |
|00001930| 61 6e 20 61 6c 65 72 74 | 20 66 6c 61 67 20 69 6e |an alert| flag in|
|00001940| 20 63 6f 6c 75 6d 6e 20 | 41 20 74 68 61 74 20 67 | column |A that g|
|00001950| 65 6e 65 72 61 74 65 73 | 20 61 20 52 45 44 20 6e |enerates| a RED n|
|00001960| 65 67 61 74 69 76 65 20 | 6f 6e 65 20 28 2d 31 29 |egative |one (-1)|
|00001970| 2c 20 77 68 65 6e 20 79 | 6f 75 20 65 78 63 65 65 |, when y|ou excee|
|00001980| 64 20 79 6f 75 72 20 63 | 72 65 64 69 74 20 6c 69 |d your c|redit li|
|00001990| 6d 69 74 20 61 6c 6c 6f | 77 65 64 20 28 64 6f 6e |mit allo|wed (don|
|000019a0| 27 74 20 66 6f 72 67 65 | 74 20 74 6f 20 65 6e 74 |'t forge|t to ent|
|000019b0| 65 72 20 79 6f 75 72 20 | 63 72 65 64 69 74 20 6c |er your |credit l|
|000019c0| 69 6d 69 74 29 2e 20 41 | 6c 6c 20 77 6f 72 6b 73 |imit). A|ll works|
|000019d0| 68 65 65 74 73 20 63 61 | 6e 20 62 65 20 65 78 74 |heets ca|n be ext|
|000019e0| 65 6e 64 65 64 20 62 65 | 79 6f 6e 64 20 74 68 65 |ended be|yond the|
|000019f0| 69 72 20 63 75 72 72 65 | 6e 74 20 6c 65 6e 67 74 |ir curre|nt lengt|
|00001a00| 68 2c 20 61 6e 64 20 6c | 69 6e 6b 65 64 20 74 6f |h, and l|inked to|
|00001a10| 20 61 64 64 69 74 69 6f | 6e 61 6c 20 79 65 61 72 | additio|nal year|
|00001a20| 73 2e 20 20 49 66 20 79 | 6f 75 20 77 69 73 68 20 |s. If y|ou wish |
|00001a30| 74 6f 20 67 65 74 20 61 | 20 68 61 6e 64 6c 65 20 |to get a| handle |
|00001a40| 6f 6e 20 79 6f 75 72 20 | 6d 6f 6e 65 79 2c 20 74 |on your |money, t|
|00001a50| 68 65 6e 20 49 20 77 6f | 75 6c 64 20 73 75 67 67 |hen I wo|uld sugg|
|00001a60| 65 73 74 20 79 6f 75 20 | 73 74 61 72 74 20 74 72 |est you |start tr|
|00001a70| 61 63 6b 69 6e 67 20 79 | 6f 75 72 20 66 69 6e 61 |acking y|our fina|
|00001a80| 6e 63 65 73 20 77 69 74 | 68 20 61 20 66 65 72 76 |nces wit|h a ferv|
|00001a90| 6f 72 2e 0d 0d 0d 54 68 | 65 20 25 20 73 79 6d 62 |or....Th|e % symb|
|00001aa0| 6f 6c 20 73 69 67 6e 69 | 66 69 65 73 20 77 68 61 |ol signi|fies wha|
|00001ab0| 74 20 49 20 73 65 65 20 | 61 73 20 61 20 20 4c 4f |t I see |as a LO|
|00001ac0| 4e 47 20 54 45 52 4d 20 | 63 72 65 64 69 74 20 66 |NG TERM |credit f|
|00001ad0| 69 6e 61 6e 63 65 20 61 | 63 63 6f 75 6e 74 0d 0d |inance a|ccount..|
|00001ae0| 34 2e 20 25 20 44 45 50 | 41 52 54 4d 45 4e 54 20 |4. % DEP|ARTMENT |
|00001af0| 53 54 4f 52 45 20 0d 35 | 2e 20 25 20 46 55 52 4e |STORE .5|. % FURN|
|00001b00| 49 54 55 52 45 20 53 54 | 4f 52 45 0d 36 2e 20 25 |ITURE ST|ORE.6. %|
|00001b10| 20 4d 41 53 54 45 52 43 | 41 52 44 0d 37 2e 20 25 | MASTERC|ARD.7. %|
|00001b20| 20 4f 54 48 45 52 20 43 | 52 45 44 49 54 20 31 0d | OTHER C|REDIT 1.|
|00001b30| 38 2e 20 25 20 56 49 53 | 41 0d 39 2e 20 25 20 56 |8. % VIS|A.9. % V|
|00001b40| 45 48 49 43 4c 45 20 50 | 55 52 43 48 41 53 45 0d |EHICLE P|URCHASE.|
|00001b50| 0d 54 68 65 20 a2 20 73 | 79 6d 62 6f 6c 20 73 69 |.The . s|ymbol si|
|00001b60| 67 6e 69 66 69 65 73 20 | 77 68 61 74 20 49 20 73 |gnifies |what I s|
|00001b70| 65 65 20 61 73 20 61 20 | 53 48 4f 52 54 20 54 45 |ee as a |SHORT TE|
|00001b80| 52 4d 20 63 72 65 64 69 | 74 20 66 69 6e 61 6e 63 |RM credi|t financ|
|00001b90| 65 20 61 63 63 6f 75 6e | 74 0d 0d 31 30 2e 20 a2 |e accoun|t..10. .|
|00001ba0| 20 50 45 52 53 4f 4e 41 | 4c 20 4c 4f 41 4e 20 31 | PERSONA|L LOAN 1|
|00001bb0| 0d 31 31 2e 20 a2 20 50 | 45 52 53 4f 4e 41 4c 20 |.11. . P|ERSONAL |
|00001bc0| 4c 4f 41 4e 20 32 0d 0d | 54 68 65 20 6e 65 78 74 |LOAN 2..|The next|
|00001bd0| 20 77 6f 72 6b 73 68 65 | 65 74 20 73 68 6f 75 6c | workshe|et shoul|
|00001be0| 64 20 62 65 20 75 73 65 | 64 20 74 6f 20 68 65 6c |d be use|d to hel|
|00001bf0| 70 20 73 63 68 65 64 75 | 6c 65 20 76 61 63 61 74 |p schedu|le vacat|
|00001c00| 69 6f 6e 73 2c 20 61 6e | 64 20 6b 65 65 70 20 74 |ions, an|d keep t|
|00001c10| 72 61 63 6b 20 6f 66 20 | 73 69 63 6b 2c 20 68 6f |rack of |sick, ho|
|00001c20| 6c 69 64 61 79 2c 20 61 | 6e 64 20 76 61 63 61 74 |liday, a|nd vacat|
|00001c30| 69 6f 6e 20 74 69 6d 65 | 20 74 61 6b 65 6e 2e 20 |ion time| taken. |
|00001c40| 49 66 20 79 6f 75 20 63 | 61 6e 20 74 75 72 6e 20 |If you c|an turn |
|00001c50| 69 6e 20 74 69 6d 65 20 | 65 61 72 6e 65 64 20 66 |in time |earned f|
|00001c60| 6f 72 20 61 20 63 61 73 | 68 20 70 61 79 6d 65 6e |or a cas|h paymen|
|00001c70| 74 2c 20 74 68 65 6e 20 | 74 68 69 73 20 77 6f 72 |t, then |this wor|
|00001c80| 6b 73 68 65 65 74 20 77 | 69 6c 6c 20 61 6c 73 6f |ksheet w|ill also|
|00001c90| 20 68 65 6c 70 20 79 6f | 75 20 70 6c 61 6e 20 66 | help yo|u plan f|
|00001ca0| 6f 72 20 74 68 65 20 65 | 6c 69 67 69 62 6c 65 20 |or the e|ligible |
|00001cb0| 64 61 74 65 28 73 29 2e | 0d 0d 31 32 2e 20 54 49 |date(s).|..12. TI|
|00001cc0| 4d 45 20 41 43 43 52 55 | 41 4c 20 57 4f 52 4b 53 |ME ACCRU|AL WORKS|
|00001cd0| 48 45 45 54 0d 0d 54 68 | 65 20 6c 61 73 74 20 77 |HEET..Th|e last w|
|00001ce0| 6f 72 6b 73 68 65 65 74 | 20 69 73 20 74 68 65 20 |orksheet| is the |
|00001cf0| 68 69 64 64 65 6e 20 62 | 61 63 6b 62 6f 6e 65 73 |hidden b|ackbones|
|00001d00| 20 20 6f 66 20 74 68 65 | 20 77 68 6f 6c 65 20 73 | of the| whole s|
|00001d10| 79 73 74 65 6d 20 2d 20 | 44 45 4c 45 54 45 20 74 |ystem - |DELETE t|
|00001d20| 68 69 73 20 61 6e 64 2f | 6f 72 20 63 68 61 6e 67 |his and/|or chang|
|00001d30| 65 20 74 68 65 20 6e 61 | 6d 65 20 61 6e 64 20 79 |e the na|me and y|
|00001d40| 6f 75 20 68 61 76 65 20 | 48 4f 53 45 44 20 28 6c |ou have |HOSED (l|
|00001d50| 6f 73 74 20 66 6f 72 65 | 76 65 72 29 20 79 6f 75 |ost fore|ver) you|
|00001d60| 72 20 61 75 74 6f 6d 61 | 74 69 6f 6e 20 74 69 65 |r automa|tion tie|
|00001d70| 2d 69 6e 73 2e 0d 0d 31 | 33 2e 20 42 49 57 45 45 |-ins...1|3. BIWEE|
|00001d80| 4b 4c 59 20 4d 41 43 52 | 4f 27 53 20 0d 0d 54 68 |KLY MACR|O'S ..Th|
|00001d90| 65 20 42 69 57 65 65 6b | 6c 79 20 4d 61 63 72 6f |e BiWeek|ly Macro|
|00001da0| 27 73 20 73 74 6f 72 65 | 20 61 6c 6c 20 74 68 65 |'s store| all the|
|00001db0| 20 6c 69 6e 6b 73 20 74 | 6f 20 74 68 65 20 67 72 | links t|o the gr|
|00001dc0| 61 70 68 69 63 73 2c 20 | 61 6e 64 20 65 61 63 68 |aphics, |and each|
|00001dd0| 20 6e 65 77 20 77 6f 72 | 6b 73 68 65 65 74 20 63 | new wor|ksheet c|
|00001de0| 72 65 61 74 65 64 20 66 | 72 6f 6d 20 74 68 65 20 |reated f|rom the |
|00001df0| 42 69 57 65 65 6b 6c 79 | 20 32 36 2f 32 37 20 42 |BiWeekly| 26/27 B|
|00001e00| 75 64 67 65 74 20 54 65 | 6d 70 6c 61 74 65 2e 20 |udget Te|mplate. |
|00001e10| 20 48 6f 77 65 76 65 72 | 2c 20 61 73 20 79 6f 75 | However|, as you|
|00001e20| 20 69 6e 73 65 72 74 20 | 72 6f 77 28 73 29 2c 20 | insert |row(s), |
|00001e30| 74 68 65 72 65 20 77 69 | 6c 6c 20 62 65 20 6e 6f |there wi|ll be no|
|00001e40| 20 27 52 45 50 45 41 54 | 27 20 62 75 74 74 6f 6e | 'REPEAT|' button|
|00001e50| 20 66 6f 72 20 74 68 61 | 74 20 70 61 72 74 69 63 | for tha|t partic|
|00001e60| 75 6c 61 72 20 72 6f 77 | 28 73 29 2e 20 49 66 20 |ular row|(s). If |
|00001e70| 79 6f 75 20 6b 6e 6f 77 | 20 68 6f 77 20 74 6f 20 |you know| how to |
|00001e80| 63 6f 70 79 20 6f 62 6a | 65 63 74 73 2c 20 6d 61 |copy obj|ects, ma|
|00001e90| 63 72 6f 27 73 2c 20 61 | 6e 64 20 64 65 66 69 6e |cro's, a|nd defin|
|00001ea0| 65 20 61 20 6e 61 6d 65 | 2c 20 74 68 65 6e 20 61 |e a name|, then a|
|00001eb0| 6c 6c 20 79 6f 75 20 6e | 65 65 64 20 74 6f 20 64 |ll you n|eed to d|
|00001ec0| 6f 20 69 73 20 61 63 63 | 65 73 73 20 74 68 65 20 |o is acc|ess the |
|00001ed0| 6d 61 63 72 6f 20 77 6f | 72 6b 73 68 65 65 74 2c |macro wo|rksheet,|
|00001ee0| 20 63 72 65 61 74 65 20 | 74 68 65 20 6e 65 77 20 | create |the new |
|00001ef0| 6d 61 63 72 6f 2c 20 61 | 6e 64 20 74 68 65 6e 20 |macro, a|nd then |
|00001f00| 61 73 73 69 67 6e 20 74 | 68 65 20 6e 65 77 20 6f |assign t|he new o|
|00001f10| 62 6a 65 63 74 20 74 6f | 20 69 74 20 28 4d 61 6b |bject to| it (Mak|
|00001f20| 65 20 73 75 72 65 20 61 | 66 74 65 72 20 64 6f 69 |e sure a|fter doi|
|00001f30| 6e 67 20 74 68 69 73 20 | 74 6f 20 72 65 6d 6f 76 |ng this |to remov|
|00001f40| 65 20 74 68 65 20 63 75 | 72 72 65 6e 74 20 6d 61 |e the cu|rrent ma|
|00001f50| 63 72 6f 20 61 73 73 69 | 67 6e 6d 65 6e 74 20 66 |cro assi|gnment f|
|00001f60| 72 6f 6d 20 74 68 65 20 | 6e 65 77 20 62 75 74 74 |rom the |new butt|
|00001f70| 6f 6e 2e 20 4e 6f 74 20 | 64 6f 69 6e 67 20 73 6f |on. Not |doing so|
|00001f80| 20 77 69 6c 6c 20 66 6f | 73 74 65 72 20 75 6e 77 | will fo|ster unw|
|00001f90| 61 6e 74 65 64 20 65 6e | 74 72 69 65 73 20 6f 6e |anted en|tries on|
|00001fa0| 20 79 6f 75 72 20 4e 45 | 57 20 57 4f 52 4b 53 48 | your NE|W WORKSH|
|00001fb0| 45 45 54 29 2e 20 49 66 | 20 79 6f 75 20 77 6f 75 |EET). If| you wou|
|00001fc0| 6c 64 20 6c 69 6b 65 20 | 68 65 6c 70 20 63 75 73 |ld like |help cus|
|00001fd0| 74 6f 6d 69 7a 69 6e 67 | 20 66 75 72 74 68 65 72 |tomizing| further|
|00001fe0| 20 6a 75 73 74 20 6c 65 | 74 20 6d 65 20 6b 6e 6f | just le|t me kno|
|00001ff0| 77 20 62 79 20 45 2d 6d | 61 69 6c 20 28 76 69 61 |w by E-m|ail (via|
|00002000| 20 41 4f 4c 20 44 41 56 | 49 44 45 4f 35 34 30 29 | AOL DAV|IDEO540)|
|00002010| 2e 20 57 41 52 4e 49 4e | 47 3a 20 42 45 46 4f 52 |. WARNIN|G: BEFOR|
|00002020| 45 20 59 4f 55 20 44 45 | 4c 45 54 45 20 41 20 52 |E YOU DE|LETE A R|
|00002030| 4f 57 2c 20 53 45 4c 45 | 43 54 20 54 48 45 20 27 |OW, SELE|CT THE '|
|00002040| 52 45 50 45 41 54 27 20 | 42 55 54 54 4f 4e 20 4f |REPEAT' |BUTTON O|
|00002050| 4e 20 54 48 41 54 20 52 | 4f 57 20 57 49 54 48 20 |N THAT R|OW WITH |
|00002060| 54 48 45 20 53 45 4c 45 | 43 54 20 53 50 45 43 49 |THE SELE|CT SPECI|
|00002070| 41 4c 20 4f 50 54 49 4f | 4e 2c 20 41 4e 44 20 44 |AL OPTIO|N, AND D|
|00002080| 45 4c 45 54 45 20 54 48 | 49 53 20 46 49 52 53 54 |ELETE TH|IS FIRST|
|00002090| 2e 20 54 48 45 4e 20 41 | 4e 44 20 4f 4e 4c 59 20 |. THEN A|ND ONLY |
|000020a0| 54 48 45 4e 2c 20 44 45 | 4c 45 54 45 20 54 48 45 |THEN, DE|LETE THE|
|000020b0| 20 52 4f 57 2e 20 41 6c | 73 6f 2c 20 74 68 65 20 | ROW. Al|so, the |
|000020c0| 6d 61 63 72 6f 20 73 68 | 65 65 74 20 63 6f 6e 74 |macro sh|eet cont|
|000020d0| 61 69 6e 73 20 74 68 65 | 20 61 75 74 6f 6d 61 74 |ains the| automat|
|000020e0| 69 6f 6e 20 74 68 65 20 | 77 6f 72 6b 73 68 65 65 |ion the |workshee|
|000020f0| 74 20 75 74 69 6c 69 7a | 65 73 2e 20 0d 0d 49 20 |t utiliz|es. ..I |
|00002100| 63 6f 75 6c 64 20 68 61 | 76 65 20 63 72 65 61 74 |could ha|ve creat|
|00002110| 65 64 20 6d 61 6e 79 20 | 61 64 64 69 74 69 6f 6e |ed many |addition|
|00002120| 61 6c 20 77 6f 72 6b 73 | 68 65 65 74 73 20 74 68 |al works|heets th|
|00002130| 61 74 20 74 69 65 20 69 | 6e 2e 20 46 6f 72 20 6f |at tie i|n. For o|
|00002140| 75 72 20 62 75 64 67 65 | 74 20 49 20 68 61 76 65 |ur budge|t I have|
|00002150| 2c 20 69 6e 63 6c 75 64 | 69 6e 67 20 6e 65 61 74 |, includ|ing neat|
|00002160| 20 66 6f 72 6d 75 6c 61 | 73 20 74 68 61 74 20 63 | formula|s that c|
|00002170| 6f 6d 70 75 74 65 20 79 | 6f 75 72 20 74 61 78 20 |ompute y|our tax |
|00002180| 64 65 64 75 63 74 69 6f | 6e 73 2c 20 74 68 61 74 |deductio|ns, that|
|00002190| 20 63 6f 6e 73 69 64 65 | 72 73 20 76 61 72 79 69 | conside|rs varyi|
|000021a0| 6e 67 20 79 6f 75 72 20 | 65 78 65 6d 70 74 69 6f |ng your |exemptio|
|000021b0| 6e 73 20 61 6e 64 2f 6f | 72 20 70 61 79 20 69 6e |ns and/o|r pay in|
|000021c0| 63 72 65 61 73 65 73 20 | 28 68 6f 70 65 66 75 6c |creases |(hopeful|
|000021d0| 6c 79 29 2e 20 49 66 20 | 79 6f 75 20 61 72 65 20 |ly). If |you are |
|000021e0| 69 6e 74 65 72 65 73 74 | 65 64 20 6f 6e 20 68 6f |interest|ed on ho|
|000021f0| 77 20 74 6f 20 64 6f 20 | 73 6f 2c 20 73 65 6e 64 |w to do |so, send|
|00002200| 20 6d 65 20 73 6f 6d 65 | 20 45 2d 6d 61 69 6c 20 | me some| E-mail |
|00002210| 28 76 69 61 20 41 4f 4c | 20 44 41 56 49 44 45 4f |(via AOL| DAVIDEO|
|00002220| 35 34 30 29 2e 20 49 20 | 61 6d 20 65 61 67 65 72 |540). I |am eager|
|00002230| 20 74 6f 20 6c 65 6e 64 | 20 61 20 68 61 6e 64 20 | to lend| a hand |
|00002240| 69 66 20 49 20 63 61 6e | 2e 0d 0d 59 6f 75 20 63 |if I can|...You c|
|00002250| 61 6e 20 6d 61 6b 65 20 | 74 68 65 20 42 49 57 45 |an make |the BIWE|
|00002260| 45 4b 4c 59 20 57 4f 52 | 4b 42 4f 4f 4b 20 64 6f |EKLY WOR|KBOOK do|
|00002270| 20 69 6d 70 6f 72 74 61 | 6e 74 20 74 61 73 6b 73 | importa|nt tasks|
|00002280| 2e 20 48 6f 77 20 76 61 | 6c 75 61 62 6c 65 20 69 |. How va|luable i|
|00002290| 74 20 62 65 63 6f 6d 65 | 73 20 69 73 20 72 65 61 |t become|s is rea|
|000022a0| 6c 6c 79 20 75 70 20 74 | 6f 20 79 6f 75 2c 20 61 |lly up t|o you, a|
|000022b0| 6e 64 20 79 6f 75 20 61 | 6c 6f 6e 65 2e 20 57 69 |nd you a|lone. Wi|
|000022c0| 74 68 20 74 68 65 20 61 | 69 64 20 6f 66 20 79 6f |th the a|id of yo|
|000022d0| 75 72 20 63 6f 6d 70 75 | 74 65 72 20 28 74 6f 20 |ur compu|ter (to |
|000022e0| 64 6f 20 61 6c 6c 20 74 | 68 65 20 72 65 61 6c 20 |do all t|he real |
|000022f0| 77 6f 72 6b 29 2c 20 61 | 20 70 72 69 6e 74 65 72 |work), a| printer|
|00002300| 20 28 66 6f 72 20 68 61 | 72 64 20 63 6f 70 69 65 | (for ha|rd copie|
|00002310| 73 29 2c 20 61 6e 64 20 | 73 6f 6d 65 20 33 2e 35 |s), and |some 3.5|
|00002320| 22 20 66 6c 6f 70 70 69 | 65 73 20 28 66 6f 72 20 |" floppi|es (for |
|00002330| 61 72 63 68 69 76 61 6c | 20 70 75 72 70 6f 73 65 |archival| purpose|
|00002340| 73 29 2c 20 72 65 63 6f | 72 64 20 6b 65 65 70 69 |s), reco|rd keepi|
|00002350| 6e 67 20 63 61 6e 20 62 | 65 20 70 65 72 6d 61 6e |ng can b|e perman|
|00002360| 65 6e 74 2c 20 61 6e 64 | 20 6d 75 63 68 20 65 61 |ent, and| much ea|
|00002370| 73 69 65 72 2e 0d 0d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |sier...-|--------|
|00002380| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002390| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000023a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000023b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000023c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000023d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000023e0| 2d 2d 2d 0d 0d 54 68 65 | 20 49 63 6f 6e 73 20 77 |---..The| Icons w|
|000023f0| 65 72 65 20 63 72 65 61 | 74 65 64 20 74 6f 20 68 |ere crea|ted to h|
|00002400| 65 6c 70 20 79 6f 75 20 | 71 75 69 63 6b 6c 79 20 |elp you |quickly |
|00002410| 6c 6f 63 61 74 65 20 61 | 6e 64 20 73 65 70 61 72 |locate a|nd separ|
|00002420| 61 74 65 20 74 68 65 6d | 20 66 72 6f 6d 20 79 6f |ate them| from yo|
|00002430| 75 72 20 6f 74 68 65 72 | 20 4d 69 63 72 6f 73 6f |ur other| Microso|
|00002440| 66 74 a8 20 45 78 63 65 | 6c 20 66 69 6c 65 73 2e |ft. Exce|l files.|
|00002450| 20 4a 75 73 74 20 72 65 | 6d 65 6d 62 65 72 2c 20 | Just re|member, |
|00002460| 74 68 61 74 20 65 61 63 | 68 20 74 69 6d 65 20 79 |that eac|h time y|
|00002470| 6f 75 20 63 72 65 61 74 | 65 20 61 20 6e 65 77 20 |ou creat|e a new |
|00002480| 77 6f 72 6b 73 68 65 65 | 74 20 66 72 6f 6d 20 74 |workshee|t from t|
|00002490| 68 65 20 74 65 6d 70 6c | 61 74 65 20 61 62 6f 76 |he templ|ate abov|
|000024a0| 65 2c 20 69 74 20 77 69 | 6c 6c 20 68 61 76 65 20 |e, it wi|ll have |
|000024b0| 74 68 65 20 6f 72 69 67 | 69 6e 61 6c 20 69 63 6f |the orig|inal ico|
|000024c0| 6e 20 74 68 61 74 20 69 | 73 20 6e 6f 72 6d 61 6c |n that i|s normal|
|000024d0| 6c 79 20 67 65 6e 65 72 | 61 74 65 64 20 66 6f 72 |ly gener|ated for|
|000024e0| 20 61 20 77 6f 72 6b 73 | 68 65 65 74 2e 20 20 41 | a works|heet. A|
|000024f0| 6c 6c 20 79 6f 75 20 6e | 65 65 64 20 74 6f 20 64 |ll you n|eed to d|
|00002500| 6f 20 69 73 20 63 75 74 | 20 61 6e 64 20 70 61 73 |o is cut| and pas|
|00002510| 74 65 20 74 68 65 20 72 | 65 64 2f 67 72 61 79 20 |te the r|ed/gray |
|00002520| 69 63 6f 6e 20 6f 76 65 | 72 20 69 74 20 28 66 72 |icon ove|r it (fr|
|00002530| 6f 6d 20 74 68 65 20 67 | 65 74 20 69 6e 66 6f 20 |om the g|et info |
|00002540| 77 69 6e 64 6f 77 29 2e | 20 20 54 68 65 20 72 65 |window).| The re|
|00002550| 73 74 20 6f 66 20 74 68 | 65 20 69 63 6f 6e 73 20 |st of th|e icons |
|00002560| 61 72 65 20 70 65 72 6d | 61 6e 65 6e 74 2e 20 20 |are perm|anent. |
|00002570| 4f 66 20 63 6f 75 72 73 | 65 2c 20 69 66 20 74 68 |Of cours|e, if th|
|00002580| 65 20 69 63 6f 6e 73 20 | 65 76 65 72 20 74 75 72 |e icons |ever tur|
|00002590| 6e 20 67 65 6e 65 72 69 | 63 20 6a 75 73 74 20 72 |n generi|c just r|
|000025a0| 65 62 75 69 6c 64 20 79 | 6f 75 72 20 64 65 73 6b |ebuild y|our desk|
|000025b0| 74 6f 70 2e 0d 0d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |top...--|--------|
|000025c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000025d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000025e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000025f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002600| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002610| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002620| 2d 2d 0d 0d 54 68 65 20 | 27 4e 45 57 20 57 4f 52 |--..The |'NEW WOR|
|00002630| 4b 53 48 45 45 54 27 20 | 74 68 61 74 20 69 73 20 |KSHEET' |that is |
|00002640| 67 65 6e 65 72 61 74 65 | 64 20 77 68 65 6e 20 79 |generate|d when y|
|00002650| 6f 75 20 66 69 72 73 74 | 20 6f 70 65 6e 20 74 68 |ou first| open th|
|00002660| 65 20 74 65 6d 70 6c 61 | 74 65 20 6e 65 65 64 73 |e templa|te needs|
|00002670| 20 73 6f 6d 65 20 69 6e | 2d 64 65 70 74 68 20 69 | some in|-depth i|
|00002680| 6e 66 6f 72 6d 61 74 69 | 6f 6e 2e 20 20 46 69 72 |nformati|on. Fir|
|00002690| 73 74 20 74 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |st the f|ollowing|
|000026a0| 20 73 65 74 74 69 6e 67 | 73 20 61 72 65 20 73 65 | setting|s are se|
|000026b0| 6c 65 63 74 65 64 2c 20 | 6f 72 20 6d 61 79 20 6e |lected, |or may n|
|000026c0| 65 65 64 20 74 6f 20 62 | 65 3a 0d 0d a5 20 43 61 |eed to b|e:... Ca|
|000026d0| 6c 63 75 6c 61 74 69 6f | 6e 20 68 61 73 20 62 65 |lculatio|n has be|
|000026e0| 65 6e 20 74 75 72 6e 65 | 64 20 6f 66 66 20 28 45 |en turne|d off (E|
|000026f0| 76 65 6e 20 77 69 74 68 | 20 61 20 46 50 55 20 69 |ven with| a FPU i|
|00002700| 6e 73 74 61 6c 6c 65 64 | 2c 20 74 68 69 73 20 69 |nstalled|, this i|
|00002710| 73 20 6e 65 63 65 73 73 | 61 72 79 21 29 20 54 68 |s necess|ary!) Th|
|00002720| 69 73 20 77 69 6c 6c 20 | 61 6c 6c 6f 77 20 79 6f |is will |allow yo|
|00002730| 75 20 74 6f 20 75 73 65 | 20 74 68 65 20 55 4e 44 |u to use| the UND|
|00002740| 4f 20 6f 70 74 69 6f 6e | 20 69 6d 6d 65 64 69 61 |O option| immedia|
|00002750| 74 65 6c 79 20 61 66 74 | 65 72 20 6d 69 73 74 61 |tely aft|er mista|
|00002760| 6b 65 73 2e 0d 0d 45 78 | 61 6d 70 6c 65 3a 20 49 |kes...Ex|ample: I|
|00002770| 66 20 79 6f 75 20 70 72 | 65 73 73 20 74 68 65 20 |f you pr|ess the |
|00002780| 27 52 45 50 45 41 54 27 | 20 62 75 74 74 6f 6e 20 |'REPEAT'| button |
|00002790| 61 6e 64 20 63 68 61 6e | 67 65 20 79 6f 75 72 20 |and chan|ge your |
|000027a0| 6d 69 6e 64 20 6f 72 20 | 6a 75 73 74 20 77 69 73 |mind or |just wis|
|000027b0| 68 20 74 6f 20 72 65 6d | 6f 76 65 20 74 68 65 20 |h to rem|ove the |
|000027c0| 6e 65 77 20 64 61 74 61 | 2c 0d 73 65 6c 65 63 74 |new data|,.select|
|000027d0| 69 6e 67 20 74 68 65 20 | 55 4e 44 4f 20 6f 70 74 |ing the |UNDO opt|
|000027e0| 69 6f 6e 20 77 69 6c 6c | 20 72 65 6d 6f 76 65 20 |ion will| remove |
|000027f0| 65 76 65 72 79 74 68 69 | 6e 67 20 6f 6e 20 74 68 |everythi|ng on th|
|00002800| 61 74 20 72 6f 77 20 79 | 6f 75 20 6a 75 73 74 20 |at row y|ou just |
|00002810| 65 6e 74 65 72 65 64 20 | 66 72 6f 6d 20 63 6f 6c |entered |from col|
|00002820| 75 6d 6e 20 45 20 74 68 | 72 6f 75 67 68 20 63 6f |umn E th|rough co|
|00002830| 6c 75 6d 6e 20 41 44 2e | 20 48 4f 57 45 56 45 52 |lumn AD.| HOWEVER|
|00002840| 2c 20 74 68 65 20 6e 65 | 77 20 76 61 6c 75 65 20 |, the ne|w value |
|00002850| 69 6e 20 63 6f 6c 75 6d | 6e 20 44 20 77 69 6c 6c |in colum|n D will|
|00002860| 20 6e 65 65 64 20 74 6f | 20 62 65 20 64 65 6c 65 | need to| be dele|
|00002870| 74 65 64 20 62 79 20 79 | 6f 75 2e 20 20 42 65 66 |ted by y|ou. Bef|
|00002880| 6f 72 65 20 79 6f 75 20 | 73 74 61 72 74 20 79 6f |ore you |start yo|
|00002890| 75 72 20 62 75 64 67 65 | 74 20 77 68 79 20 6e 6f |ur budge|t why no|
|000028a0| 74 20 65 78 70 65 72 69 | 6d 65 6e 74 20 66 69 72 |t experi|ment fir|
|000028b0| 73 74 2e 20 54 65 73 74 | 20 61 20 62 75 74 74 6f |st. Test| a butto|
|000028c0| 6e 28 73 29 2c 20 61 6e | 64 20 74 68 65 6e 20 73 |n(s), an|d then s|
|000028d0| 65 6c 65 63 74 20 75 6e | 64 6f 2e 0d 0d 20 0d 20 |elect un|do... . |
|000028e0| 20 20 20 20 20 20 20 20 | 52 45 4d 45 4d 42 45 52 | |REMEMBER|
|000028f0| 2c 20 54 48 45 20 55 4e | 44 4f 20 4f 50 54 49 4f |, THE UN|DO OPTIO|
|00002900| 4e 20 4f 4e 4c 59 20 57 | 4f 52 4b 53 20 49 46 20 |N ONLY W|ORKS IF |
|00002910| 54 48 49 53 20 49 53 20 | 59 4f 55 52 20 4e 45 58 |THIS IS |YOUR NEX|
|00002920| 54 20 4d 4f 56 45 2e 0d | 0d 20 0d 4c 61 73 74 2c |T MOVE..|. .Last,|
|00002930| 20 62 75 74 20 6e 6f 74 | 20 6c 65 61 73 74 2c 20 | but not| least, |
|00002940| 64 75 65 20 74 6f 20 74 | 68 65 20 73 69 7a 65 20 |due to t|he size |
|00002950| 61 6e 64 20 73 63 6f 70 | 65 20 6f 66 20 74 68 65 |and scop|e of the|
|00002960| 20 6d 61 63 72 6f 73 20 | 61 6e 64 20 73 70 72 65 | macros |and spre|
|00002970| 61 64 73 68 65 65 74 2c | 20 69 74 20 77 6f 75 6c |adsheet,| it woul|
|00002980| 64 20 62 65 20 65 61 73 | 69 65 72 20 66 6f 72 20 |d be eas|ier for |
|00002990| 79 6f 75 20 74 6f 20 63 | 61 6c 63 75 6c 61 74 65 |you to c|alculate|
|000029a0| 20 6f 6e 6c 79 20 77 68 | 65 6e 20 6e 65 63 65 73 | only wh|en neces|
|000029b0| 73 61 72 79 2e 0d 20 0d | a5 20 50 72 65 63 69 73 |sary.. .|. Precis|
|000029c0| 69 6f 6e 20 61 73 20 44 | 69 73 70 6c 61 79 65 64 |ion as D|isplayed|
|000029d0| 20 66 6f 72 20 79 6f 75 | 72 20 6e 75 6d 62 65 72 | for you|r number|
|000029e0| 73 20 68 61 73 20 62 65 | 65 6e 20 73 65 6c 65 63 |s has be|en selec|
|000029f0| 74 65 64 2e 20 28 50 6c | 65 61 73 65 20 6c 65 61 |ted. (Pl|ease lea|
|00002a00| 76 65 20 66 6f 72 20 61 | 63 63 75 72 61 63 79 29 |ve for a|ccuracy)|
|00002a10| 0d 0d a5 20 54 68 65 20 | 47 72 61 70 68 69 63 73 |... The |Graphics|
|00002a20| 20 66 6f 72 20 74 68 65 | 20 50 72 69 6e 74 20 41 | for the| Print A|
|00002a30| 72 65 61 20 68 61 76 65 | 20 70 72 6f 70 65 72 74 |rea have| propert|
|00002a40| 69 65 73 20 6f 66 20 44 | 6f 6e d5 74 20 6d 6f 76 |ies of D|on.t mov|
|00002a50| 65 20 6f 72 20 73 69 7a | 65 20 77 69 74 68 20 63 |e or siz|e with c|
|00002a60| 65 6c 6c 73 2e 20 54 68 | 69 73 20 69 73 20 6e 65 |ells. Th|is is ne|
|00002a70| 63 65 73 73 61 72 79 20 | 64 75 65 20 74 6f 20 61 |cessary |due to a|
|00002a80| 20 6d 61 63 72 6f 20 74 | 68 61 74 20 63 6f 6d 70 | macro t|hat comp|
|00002a90| 72 65 73 73 65 73 20 74 | 68 65 20 70 72 69 6e 74 |resses t|he print|
|00002aa0| 6f 75 74 2e 20 49 66 20 | 74 68 69 73 20 6f 70 74 |out. If |this opt|
|00002ab0| 69 6f 6e 20 77 65 72 65 | 20 63 68 61 6e 67 65 64 |ion were| changed|
|00002ac0| 20 74 68 65 6e 20 74 68 | 65 20 6f 62 6a 65 63 74 | then th|e object|
|00002ad0| 73 20 77 6f 75 6c 64 20 | 64 69 73 61 70 70 65 61 |s would |disappea|
|00002ae0| 72 20 74 68 72 6f 75 67 | 68 20 64 65 6c 65 74 69 |r throug|h deleti|
|00002af0| 6f 6e 2e 20 50 4c 45 41 | 53 45 20 4c 45 41 56 45 |on. PLEA|SE LEAVE|
|00002b00| 20 57 45 4c 4c 20 45 4e | 4f 55 47 48 20 41 4c 4f | WELL EN|OUGH ALO|
|00002b10| 4e 45 2e 0d 0d 0d 20 20 | 20 20 20 20 20 20 20 20 |NE.... | |
|00002b20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002b30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 | | C|
|00002b40| 48 41 4e 47 45 20 54 48 | 49 53 20 55 4e 44 45 52 |HANGE TH|IS UNDER|
|00002b50| 20 4e 4f 20 43 49 52 43 | 55 4d 53 54 41 4e 43 45 | NO CIRC|UMSTANCE|
|00002b60| 53 0d 0d 0d a5 20 54 68 | 65 20 72 65 6d 61 69 6e |S.... Th|e remain|
|00002b70| 69 6e 67 20 67 72 61 70 | 68 69 63 73 20 6f 66 20 |ing grap|hics of |
|00002b80| 74 68 65 20 77 6f 72 6b | 73 68 65 65 74 20 68 61 |the work|sheet ha|
|00002b90| 76 65 20 70 72 6f 70 65 | 72 74 69 65 73 20 6f 66 |ve prope|rties of|
|00002ba0| 20 4d 6f 76 65 20 61 6e | 64 20 73 69 7a 65 20 77 | Move an|d size w|
|00002bb0| 2f 63 65 6c 6c 73 2e 20 | 54 68 69 73 20 74 61 6b |/cells. |This tak|
|00002bc0| 65 73 20 69 6e 74 6f 20 | 63 6f 6e 73 69 64 65 72 |es into |consider|
|00002bd0| 61 74 69 6f 6e 20 64 65 | 6c 65 74 69 6f 6e 73 2f |ation de|letions/|
|00002be0| 69 6e 73 65 72 74 69 6f | 6e 73 20 74 68 61 74 20 |insertio|ns that |
|00002bf0| 6d 61 79 20 6f 63 63 75 | 72 2e 0d 0d a5 20 50 72 |may occu|r.... Pr|
|00002c00| 6f 74 65 63 74 69 6f 6e | 20 69 73 20 6f 66 66 20 |otection| is off |
|00002c10| 28 49 27 6c 6c 20 6c 65 | 61 76 65 20 74 68 69 73 |(I'll le|ave this|
|00002c20| 20 75 70 20 74 6f 20 79 | 6f 75 72 20 64 69 73 63 | up to y|our disc|
|00002c30| 72 65 74 69 6f 6e 29 2e | 20 49 66 20 79 6f 75 20 |retion).| If you |
|00002c40| 77 69 73 68 20 74 6f 20 | 70 61 73 73 77 6f 72 64 |wish to |password|
|00002c50| 20 70 72 6f 74 65 63 74 | 20 79 6f 75 72 20 64 6f | protect| your do|
|00002c60| 63 75 6d 65 6e 74 73 20 | 66 72 6f 6d 20 70 72 79 |cuments |from pry|
|00002c70| 69 6e 67 20 65 79 65 73 | 2c 20 74 68 65 6e 20 79 |ing eyes|, then y|
|00002c80| 6f 75 20 77 69 6c 6c 20 | 6e 65 65 64 20 74 6f 20 |ou will |need to |
|00002c90| 73 65 6c 65 63 74 20 74 | 68 69 73 20 6f 70 74 69 |select t|his opti|
|00002ca0| 6f 6e 2e 0d 0d a5 20 49 | 66 20 79 6f 75 20 64 6f |on.... I|f you do|
|00002cb0| 20 74 75 72 6e 20 70 72 | 6f 74 65 63 74 69 6f 6e | turn pr|otection|
|00002cc0| 20 6f 6e 2c 20 6d 61 6b | 65 20 73 75 72 65 20 79 | on, mak|e sure y|
|00002cd0| 6f 75 20 68 61 76 65 20 | 74 68 65 20 47 52 49 44 |ou have |the GRID|
|00002ce0| 4c 49 4e 45 53 20 6f 70 | 74 69 6f 6e 20 4f 4e 2c |LINES op|tion ON,|
|00002cf0| 20 74 68 69 73 20 77 69 | 6c 6c 20 6d 61 6b 65 20 | this wi|ll make |
|00002d00| 74 68 65 20 61 70 70 65 | 61 72 61 6e 63 65 20 6d |the appe|arance m|
|00002d10| 6f 72 65 20 70 6c 65 61 | 73 69 6e 67 2e 0d 0d a5 |ore plea|sing....|
|00002d20| 20 57 68 65 6e 20 79 6f | 75 27 72 65 20 65 6e 74 | When yo|u're ent|
|00002d30| 65 72 69 6e 67 20 6c 6f | 74 73 20 6f 66 20 64 61 |ering lo|ts of da|
|00002d40| 74 61 20 28 61 73 20 69 | 6e 20 73 65 74 74 69 6e |ta (as i|n settin|
|00002d50| 67 20 75 70 20 79 6f 75 | 72 20 73 70 72 65 61 64 |g up you|r spread|
|00002d60| 73 68 65 65 74 29 20 69 | 74 20 77 6f 75 6c 64 20 |sheet) i|t would |
|00002d70| 62 65 20 71 75 69 63 6b | 65 72 20 74 6f 20 74 75 |be quick|er to tu|
|00002d80| 72 6e 20 6f 66 66 20 74 | 68 65 20 67 72 61 70 68 |rn off t|he graph|
|00002d90| 69 63 73 20 66 72 6f 6d | 20 74 68 65 20 44 49 53 |ics from| the DIS|
|00002da0| 50 4c 41 59 20 6d 65 6e | 75 2c 20 61 6e 64 20 74 |PLAY men|u, and t|
|00002db0| 68 65 6e 20 74 75 72 6e | 20 74 68 65 20 67 72 61 |hen turn| the gra|
|00002dc0| 70 68 69 63 73 20 62 61 | 63 6b 20 6f 6e 20 77 68 |phics ba|ck on wh|
|00002dd0| 65 6e 20 66 69 6e 69 73 | 68 65 64 2e 20 20 42 79 |en finis|hed. By|
|00002de0| 20 64 6f 69 6e 67 20 74 | 68 69 73 2c 20 69 74 20 | doing t|his, it |
|00002df0| 77 69 6c 6c 20 73 70 65 | 65 64 20 75 70 20 74 68 |will spe|ed up th|
|00002e00| 65 20 6e 65 77 20 73 63 | 72 65 65 6e 20 72 65 64 |e new sc|reen red|
|00002e10| 72 61 77 69 6e 67 20 72 | 61 74 65 2e 0d 0d 2d 2d |rawing r|ate...--|
|00002e20| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002e30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002e40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002e50| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002e60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002e70| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002e80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 0d 0d 54 68 65 20 |--------|--..The |
|00002e90| 27 4e 45 57 20 57 4f 52 | 4b 53 48 45 45 54 27 20 |'NEW WOR|KSHEET' |
|00002ea0| 69 73 20 64 69 76 69 64 | 65 64 20 69 6e 74 6f 20 |is divid|ed into |
|00002eb0| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 61 72 |the foll|owing ar|
|00002ec0| 65 61 73 20 28 73 74 61 | 72 74 69 6e 67 20 66 72 |eas (sta|rting fr|
|00002ed0| 6f 6d 20 74 68 65 20 74 | 6f 70 20 6c 65 66 74 29 |om the t|op left)|
|00002ee0| 3a 20 09 09 09 0d 0d 0d | 20 20 20 49 46 20 59 4f |: ......| IF YO|
|00002ef0| 55 20 48 41 56 45 2f 4f | 52 20 57 49 4c 4c 20 49 |U HAVE/O|R WILL I|
|00002f00| 4e 53 45 52 54 2f 44 45 | 4c 45 54 45 20 52 4f 57 |NSERT/DE|LETE ROW|
|00002f10| 28 53 29 20 54 48 45 4e | 20 41 44 4a 55 53 54 20 |(S) THEN| ADJUST |
|00002f20| 54 48 45 20 52 45 46 45 | 52 45 4e 43 45 53 20 42 |THE REFE|RENCES B|
|00002f30| 45 4c 4f 57 0d 0d a5 20 | 20 42 75 64 67 65 74 20 |ELOW... | Budget |
|00002f40| 4e 61 6d 65 20 61 6e 64 | 20 44 61 74 65 20 72 65 |Name and| Date re|
|00002f50| 67 69 6f 6e 2c 20 28 72 | 6f 77 73 20 6f 6e 65 20 |gion, (r|ows one |
|00002f60| 28 31 29 20 74 68 72 6f | 75 67 68 20 66 69 76 65 |(1) thro|ugh five|
|00002f70| 20 28 35 29 29 2e 20 59 | 6f 75 20 77 69 6c 6c 20 | (5)). Y|ou will |
|00002f80| 62 65 20 70 72 6f 6d 70 | 74 65 64 20 62 79 20 61 |be promp|ted by a|
|00002f90| 6e 20 69 6e 70 75 74 20 | 62 6f 78 20 66 6f 72 20 |n input |box for |
|00002fa0| 74 68 65 20 63 6f 72 72 | 65 63 74 20 74 79 70 65 |the corr|ect type|
|00002fb0| 20 6f 66 20 64 61 74 61 | 20 74 6f 20 65 6e 74 65 | of data| to ente|
|00002fc0| 72 2e 0d 0d a5 09 42 69 | 57 65 65 6b 6c 79 20 4e |r.....Bi|Weekly N|
|00002fd0| 75 6d 62 65 72 73 2c 20 | 28 72 6f 77 20 73 65 76 |umbers, |(row sev|
|00002fe0| 65 6e 20 28 37 29 29 2e | 20 54 68 69 73 20 77 69 |en (7)).| This wi|
|00002ff0| 6c 6c 20 72 61 6e 67 65 | 20 66 72 6f 6d 20 6f 6e |ll range| from on|
|00003000| 65 20 74 68 72 6f 75 67 | 68 20 74 77 65 6e 74 79 |e throug|h twenty|
|00003010| 2d 65 69 67 68 74 20 28 | 32 38 29 20 66 6f 72 20 |-eight (|28) for |
|00003020| 74 68 65 20 63 6f 72 72 | 65 73 70 6f 6e 64 69 6e |the corr|espondin|
|00003030| 67 20 62 69 77 65 65 6b | 73 20 6f 6e 20 79 6f 75 |g biweek|s on you|
|00003040| 72 20 6e 65 77 20 62 75 | 64 67 65 74 20 77 6f 72 |r new bu|dget wor|
|00003050| 6b 73 68 65 65 74 2e 20 | 52 65 6d 65 6d 62 65 72 |ksheet. |Remember|
|00003060| 20 74 77 65 6e 74 79 2d | 73 65 76 65 6e 20 28 32 | twenty-|seven (2|
|00003070| 37 29 20 69 73 20 6f 6e | 6c 79 20 75 73 65 64 20 |7) is on|ly used |
|00003080| 77 68 65 6e 20 74 68 61 | 74 20 6c 61 73 74 20 62 |when tha|t last b|
|00003090| 69 77 65 65 6b 20 6f 66 | 20 74 68 65 20 79 65 61 |iweek of| the yea|
|000030a0| 72 20 69 73 20 73 74 69 | 6c 6c 20 69 6e 20 74 68 |r is sti|ll in th|
|000030b0| 65 20 73 61 6d 65 20 79 | 65 61 72 2e 20 20 49 74 |e same y|ear. It|
|000030c0| 20 77 69 6c 6c 20 62 65 | 20 6f 66 20 6e 6f 20 75 | will be| of no u|
|000030d0| 73 65 20 77 68 65 6e 20 | 74 68 61 74 20 62 69 77 |se when |that biw|
|000030e0| 65 65 6b 20 66 61 6c 6c | 73 20 69 6e 74 6f 20 74 |eek fall|s into t|
|000030f0| 68 65 20 6e 65 78 74 20 | 63 61 6c 65 6e 64 61 72 |he next |calendar|
|00003100| 20 79 65 61 72 2e 20 42 | 69 57 65 65 6b 20 74 77 | year. B|iWeek tw|
|00003110| 65 6e 74 79 2d 65 69 67 | 68 74 20 28 32 38 29 20 |enty-eig|ht (28) |
|00003120| 69 73 20 74 68 65 20 73 | 75 6d 6d 61 72 79 20 66 |is the s|ummary f|
|00003130| 6f 72 20 74 68 65 20 65 | 6e 74 69 72 65 20 79 65 |or the e|ntire ye|
|00003140| 61 72 2e 0d 0d a5 09 49 | 6e 63 6f 6d 65 20 53 6f |ar.....I|ncome So|
|00003150| 75 72 63 65 73 2c 20 28 | 72 6f 77 73 20 6e 69 6e |urces, (|rows nin|
|00003160| 65 20 28 39 29 20 74 68 | 72 6f 75 67 68 20 66 6f |e (9) th|rough fo|
|00003170| 75 72 74 65 65 6e 20 28 | 31 34 29 29 2e 20 54 68 |urteen (|14)). Th|
|00003180| 69 73 20 63 68 61 6e 67 | 65 73 20 66 6f 72 20 65 |is chang|es for e|
|00003190| 61 63 68 20 70 65 72 73 | 6f 6e 28 73 29 20 72 65 |ach pers|on(s) re|
|000031a0| 71 75 69 72 65 6d 65 6e | 74 73 2e 20 20 49 66 20 |quiremen|ts. If |
|000031b0| 79 6f 75 20 66 69 6e 64 | 20 74 68 61 74 20 74 68 |you find| that th|
|000031c0| 65 72 65 20 61 72 65 20 | 74 6f 6f 20 6d 61 6e 79 |ere are |too many|
|000031d0| 20 72 6f 77 73 20 66 6f | 72 20 79 6f 75 72 20 69 | rows fo|r your i|
|000031e0| 6e 63 6f 6d 65 20 6e 65 | 65 64 73 2c 20 74 68 65 |ncome ne|eds, the|
|000031f0| 6e 20 77 68 79 20 6e 6f | 74 20 75 73 65 20 74 68 |n why no|t use th|
|00003200| 65 20 75 6e 6e 65 63 65 | 73 73 61 72 79 20 72 6f |e unnece|ssary ro|
|00003210| 77 28 73 29 20 66 6f 72 | 20 4c 4f 4e 47 20 54 45 |w(s) for| LONG TE|
|00003220| 52 4d 20 63 72 65 64 69 | 74 20 61 64 76 61 6e 63 |RM credi|t advanc|
|00003230| 65 73 2c 20 61 6e 64 20 | 20 74 68 65 6e 20 6c 69 |es, and | then li|
|00003240| 6e 6b 20 74 68 65 6d 20 | 74 6f 20 74 68 65 20 61 |nk them |to the a|
|00003250| 70 70 72 6f 70 72 69 61 | 74 65 20 77 6f 72 6b 62 |ppropria|te workb|
|00003260| 6f 6f 6b 20 77 6f 72 6b | 73 68 65 65 74 2e 20 49 |ook work|sheet. I|
|00003270| 20 64 69 64 21 21 21 20 | 20 4c 69 6e 6b 69 6e 67 | did!!! | Linking|
|00003280| 20 64 61 74 61 20 73 75 | 72 65 20 69 73 20 66 75 | data su|re is fu|
|00003290| 6e 2e 20 44 6f 6e 27 74 | 20 66 6f 72 67 65 74 2c |n. Don't| forget,|
|000032a0| 20 65 76 65 6e 20 74 68 | 6f 75 67 68 20 63 72 65 | even th|ough cre|
|000032b0| 64 69 74 20 63 61 72 64 | 20 61 64 76 61 6e 63 65 |dit card| advance|
|000032c0| 73 20 77 69 6c 6c 20 73 | 68 6f 77 20 75 70 20 61 |s will s|how up a|
|000032d0| 73 20 61 6e 20 65 78 70 | 65 6e 73 65 20 69 74 65 |s an exp|ense ite|
|000032e0| 6d 2c 20 74 68 65 79 20 | 61 72 65 20 61 6c 73 6f |m, they |are also|
|000032f0| 20 61 6e 20 69 6e 63 6f | 6d 65 20 73 6f 75 72 63 | an inco|me sourc|
|00003300| 65 2e 20 20 4f 6e 65 20 | 65 6e 74 72 79 20 73 68 |e. One |entry sh|
|00003310| 6f 75 6c 64 20 6e 65 67 | 61 74 65 20 74 68 65 20 |ould neg|ate the |
|00003320| 6f 74 68 65 72 20 65 6e | 74 72 79 2e 0d 0d a5 09 |other en|try.....|
|00003330| 43 61 72 72 79 20 46 72 | 6f 6d 20 50 72 65 76 69 |Carry Fr|om Previ|
|00003340| 6f 75 73 20 42 69 57 65 | 65 6b 2c 20 28 72 6f 77 |ous BiWe|ek, (row|
|00003350| 20 66 69 66 74 65 65 6e | 20 28 31 35 29 29 2e 20 | fifteen| (15)). |
|00003360| 54 68 69 73 20 69 73 20 | 79 6f 75 72 20 6d 6f 6e |This is |your mon|
|00003370| 65 79 20 6c 65 66 74 20 | 61 66 74 65 72 20 65 78 |ey left |after ex|
|00003380| 70 65 6e 73 65 73 20 66 | 72 6f 6d 20 74 68 65 20 |penses f|rom the |
|00003390| 70 72 65 76 69 6f 75 73 | 20 62 69 77 65 65 6b 2e |previous| biweek.|
|000033a0| 20 54 68 65 20 66 69 72 | 73 74 20 63 6f 6c 75 6d | The fir|st colum|
|000033b0| 6e 20 44 20 77 69 6c 6c | 20 65 69 74 68 65 72 20 |n D will| either |
|000033c0| 68 61 76 65 20 77 68 61 | 74 20 79 6f 75 20 65 6e |have wha|t you en|
|000033d0| 74 65 72 65 64 20 66 72 | 6f 6d 20 74 68 65 20 42 |tered fr|om the B|
|000033e0| 45 47 49 4e 20 43 41 53 | 48 20 69 6e 70 75 74 20 |EGIN CAS|H input |
|000033f0| 62 6f 78 2c 20 6f 72 20 | 77 69 6c 6c 20 65 69 74 |box, or |will eit|
|00003400| 68 65 72 20 62 65 20 6c | 69 6e 6b 65 64 20 74 6f |her be l|inked to|
|00003410| 20 74 68 65 20 70 72 65 | 76 69 6f 75 73 20 79 65 | the pre|vious ye|
|00003420| 61 72 27 73 20 65 6e 64 | 69 6e 67 20 63 61 72 72 |ar's end|ing carr|
|00003430| 79 20 28 6d 6f 6e 65 79 | 20 6c 65 66 74 20 6f 76 |y (money| left ov|
|00003440| 65 72 29 2e 0d 0d a5 09 | 54 6f 74 61 6c 20 49 6e |er).....|Total In|
|00003450| 63 6f 6d 65 2c 20 69 6e | 63 6c 75 64 69 6e 67 20 |come, in|cluding |
|00003460| 74 68 65 20 63 61 72 72 | 79 2c 20 28 72 6f 77 20 |the carr|y, (row |
|00003470| 73 65 76 65 6e 74 65 65 | 6e 20 28 31 37 29 29 2e |seventee|n (17)).|
|00003480| 20 4e 6f 74 68 69 6e 67 | 20 72 65 61 6c 6c 79 20 | Nothing| really |
|00003490| 74 6f 20 70 6f 69 6e 74 | 20 6f 75 74 20 65 78 63 |to point| out exc|
|000034a0| 65 70 74 20 66 6f 72 20 | 62 69 77 65 65 6b 20 74 |ept for |biweek t|
|000034b0| 77 65 6e 74 79 2d 73 65 | 76 65 6e 20 28 32 37 29 |wenty-se|ven (27)|
|000034c0| 20 61 67 61 69 6e 2e 20 | 20 49 74 20 77 6f 6e 27 | again. | It won'|
|000034d0| 74 20 61 64 64 20 77 68 | 65 6e 20 54 48 41 54 20 |t add wh|en THAT |
|000034e0| 42 49 57 45 45 4b 20 69 | 73 20 6e 6f 74 20 69 6e |BIWEEK i|s not in|
|000034f0| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 62 75 64 | the cur|rent bud|
|00003500| 67 65 74 20 79 65 61 72 | 2e 0d 0d a5 09 56 61 63 |get year|.....Vac|
|00003510| 61 74 69 6f 6e 20 61 6e | 64 20 4c 65 61 76 65 20 |ation an|d Leave |
|00003520| 41 63 63 72 75 61 6c 2c | 20 28 72 6f 77 20 6e 69 |Accrual,| (row ni|
|00003530| 6e 65 74 65 65 6e 20 28 | 31 39 29 29 2e 20 57 68 |neteen (|19)). Wh|
|00003540| 61 74 65 76 65 72 20 74 | 69 6d 65 20 79 6f 75 20 |atever t|ime you |
|00003550| 61 63 63 72 75 65 20 6f | 6e 20 61 20 62 69 77 65 |accrue o|n a biwe|
|00003560| 65 6b 6c 79 20 62 61 73 | 69 73 20 73 68 6f 75 6c |ekly bas|is shoul|
|00003570| 64 20 62 65 20 65 6e 74 | 65 72 65 64 20 68 65 72 |d be ent|ered her|
|00003580| 65 2c 20 77 68 65 74 68 | 65 72 20 74 68 65 72 65 |e, wheth|er there|
|00003590| 20 69 73 20 6d 6f 72 65 | 20 74 68 61 6e 20 6f 6e | is more| than on|
|000035a0| 65 20 73 6f 75 72 63 65 | 20 6f 72 20 6e 6f 74 2e |e source| or not.|
|000035b0| 20 20 49 66 20 74 68 65 | 72 65 20 61 72 65 20 74 | If the|re are t|
|000035c0| 77 6f 20 6f 72 20 6d 6f | 72 65 20 73 6f 75 72 63 |wo or mo|re sourc|
|000035d0| 65 73 20 74 68 65 6e 20 | 6a 75 73 74 20 61 64 64 |es then |just add|
|000035e0| 20 74 68 65 6d 20 6c 69 | 6b 65 20 3d 33 2b 33 2b | them li|ke =3+3+|
|000035f0| 34 2e 31 35 2e 20 20 59 | 6f 75 20 77 69 6c 6c 20 |4.15. Y|ou will |
|00003600| 6e 65 65 64 20 74 6f 20 | 64 6f 20 74 68 69 73 20 |need to |do this |
|00003610| 6f 6e 20 61 20 62 69 77 | 65 65 6b 6c 79 20 62 61 |on a biw|eekly ba|
|00003620| 73 69 73 2e 20 20 54 68 | 65 20 6c 69 6e 6b 20 61 |sis. Th|e link a|
|00003630| 72 65 61 20 6f 66 20 74 | 68 65 20 6e 65 77 20 77 |rea of t|he new w|
|00003640| 6f 72 6b 73 68 65 65 74 | 20 73 68 6f 75 6c 64 20 |orksheet| should |
|00003650| 74 68 65 6e 20 62 65 20 | 6c 69 6e 6b 65 64 20 74 |then be |linked t|
|00003660| 6f 20 74 68 65 20 63 6f | 72 72 65 63 74 20 63 6f |o the co|rrect co|
|00003670| 6c 75 6d 6e 20 69 6e 20 | 74 68 65 20 74 69 6d 65 |lumn in |the time|
|00003680| 20 61 63 63 72 75 61 6c | 20 77 6f 72 6b 73 68 65 | accrual| workshe|
|00003690| 65 74 2e 20 20 52 65 6d | 65 6d 62 65 72 20 74 68 |et. Rem|ember th|
|000036a0| 65 20 67 75 69 64 65 6c | 69 6e 65 73 20 69 6e 20 |e guidel|ines in |
|000036b0| 79 65 6c 6c 6f 77 20 2d | 20 4c 4f 4f 4b 20 46 4f |yellow -| LOOK FO|
|000036c0| 52 20 54 48 45 53 45 2e | 0d 0d a5 09 43 75 6d 75 |R THESE.|....Cumu|
|000036d0| 6c 61 74 69 76 65 20 56 | 61 63 61 74 69 6f 6e 20 |lative V|acation |
|000036e0| 61 6e 64 20 6c 65 61 76 | 65 20 69 6e 63 72 65 6d |and leav|e increm|
|000036f0| 65 6e 74 61 6c 20 61 64 | 64 69 74 69 6f 6e 73 2c |ental ad|ditions,|
|00003700| 20 28 72 6f 77 20 74 77 | 65 6e 74 79 2d 6f 6e 65 | (row tw|enty-one|
|00003710| 20 28 32 31 29 29 2e 20 | 49 20 6a 75 73 74 20 70 | (21)). |I just p|
|00003720| 75 74 20 74 68 69 73 20 | 74 68 65 72 65 20 77 69 |ut this |there wi|
|00003730| 74 68 20 74 68 65 20 61 | 70 70 72 6f 70 72 69 61 |th the a|ppropria|
|00003740| 74 65 20 66 6f 72 6d 75 | 6c 61 20 66 6f 72 20 79 |te formu|la for y|
|00003750| 6f 75 20 74 6f 20 6c 65 | 74 20 79 6f 75 20 73 65 |ou to le|t you se|
|00003760| 65 20 74 68 65 20 76 61 | 6c 75 65 73 20 61 63 63 |e the va|lues acc|
|00003770| 72 75 69 6e 67 20 6f 6e | 20 61 20 62 69 77 65 65 |ruing on| a biwee|
|00003780| 6b 6c 79 2d 74 6f 2d 62 | 69 77 65 65 6b 6c 79 20 |kly-to-b|iweekly |
|00003790| 62 61 73 69 73 2e 20 49 | 74 20 61 6c 73 6f 20 66 |basis. I|t also f|
|000037a0| 69 6c 6c 65 64 20 69 6e | 20 61 20 62 6c 61 6e 6b |illed in| a blank|
|000037b0| 20 61 72 65 61 20 6f 6e | 20 74 68 65 20 77 6f 72 | area on| the wor|
|000037c0| 6b 73 68 65 65 74 2e 0d | 09 09 0d a5 20 45 78 70 |ksheet..|.... Exp|
|000037d0| 65 6e 73 65 20 53 65 63 | 74 69 6f 6e 20 77 2f 74 |ense Sec|tion w/t|
|000037e0| 77 65 6e 74 79 2d 74 77 | 6f 20 28 32 32 29 20 63 |wenty-tw|o (22) c|
|000037f0| 61 74 65 67 6f 72 69 65 | 73 2c 20 28 72 6f 77 73 |ategorie|s, (rows|
|00003800| 20 74 77 65 6e 74 79 2d | 74 68 72 65 65 20 28 32 | twenty-|three (2|
|00003810| 33 29 20 74 68 72 6f 75 | 67 68 20 6f 6e 65 2d 68 |3) throu|gh one-h|
|00003820| 75 6e 64 72 65 64 2d 66 | 6f 72 74 79 2d 65 69 67 |undred-f|orty-eig|
|00003830| 68 74 20 28 31 34 38 29 | 29 2e 20 20 54 68 69 73 |ht (148)|). This|
|00003840| 20 69 73 20 74 68 65 20 | 6d 65 61 74 20 6f 66 20 | is the |meat of |
|00003850| 74 68 65 20 77 68 6f 6c | 65 20 62 75 64 67 65 74 |the whol|e budget|
|00003860| 2e 20 20 54 68 69 73 20 | 69 73 20 74 68 65 20 61 |. This |is the a|
|00003870| 72 65 61 20 74 68 61 74 | 20 6e 65 65 64 73 20 74 |rea that| needs t|
|00003880| 68 65 20 6d 6f 73 74 20 | 61 74 74 65 6e 74 69 6f |he most |attentio|
|00003890| 6e 20 74 6f 20 64 65 74 | 61 69 6c 2e 20 20 4b 65 |n to det|ail. Ke|
|000038a0| 65 70 69 6e 67 20 74 72 | 61 63 6b 20 6f 66 20 68 |eping tr|ack of h|
|000038b0| 6f 77 20 79 6f 75 72 20 | 6d 6f 6e 65 79 20 64 69 |ow your |money di|
|000038c0| 73 73 69 70 61 74 65 73 | 20 63 61 6e 20 62 65 20 |ssipates| can be |
|000038d0| 65 6c 75 73 69 76 65 20 | 69 66 20 79 6f 75 20 61 |elusive |if you a|
|000038e0| 72 65 20 6e 6f 74 20 63 | 61 72 65 66 75 6c 20 65 |re not c|areful e|
|000038f0| 6e 6f 75 67 68 2e 20 54 | 68 69 73 20 69 73 20 61 |nough. T|his is a|
|00003900| 6c 73 6f 20 61 6e 20 69 | 64 65 61 6c 20 61 72 65 |lso an i|deal are|
|00003910| 61 20 66 6f 72 20 62 75 | 69 6c 64 69 6e 67 20 73 |a for bu|ilding s|
|00003920| 6f 6d 65 20 66 6f 72 6d | 75 6c 61 73 2c 20 74 68 |ome form|ulas, th|
|00003930| 61 74 20 77 69 6c 6c 20 | 68 65 6c 70 20 74 6f 20 |at will |help to |
|00003940| 72 65 6d 6f 76 65 20 64 | 75 70 6c 69 63 61 74 69 |remove d|uplicati|
|00003950| 6f 6e 20 6f 66 20 73 69 | 6d 69 6c 61 72 20 77 6f |on of si|milar wo|
|00003960| 72 6b 2e 0d 0d a5 20 45 | 73 74 69 6d 61 74 65 20 |rk.... E|stimate |
|00003970| 62 75 74 74 6f 6e 2c 20 | 28 72 6f 77 20 66 69 66 |button, |(row fif|
|00003980| 74 79 2d 74 68 72 65 65 | 20 28 35 33 29 20 2d 20 |ty-three| (53) - |
|00003990| 63 65 6c 6c 20 28 43 35 | 33 29 29 2e 20 55 70 6f |cell (C5|3)). Upo|
|000039a0| 6e 20 73 65 6c 65 63 74 | 69 6f 6e 2c 20 79 6f 75 |n select|ion, you|
|000039b0| 20 77 69 6c 6c 20 62 65 | 20 6d 6f 76 65 64 20 74 | will be| moved t|
|000039c0| 6f 20 74 68 65 20 61 72 | 65 61 20 66 6f 72 20 65 |o the ar|ea for e|
|000039d0| 73 74 69 6d 61 74 69 6e | 67 20 79 6f 75 72 20 65 |stimatin|g your e|
|000039e0| 6c 65 63 74 72 69 63 20 | 75 74 69 6c 69 74 69 65 |lectric |utilitie|
|000039f0| 73 2e 20 0d 0d a5 20 50 | 61 79 63 68 65 63 6b 20 |s. ... P|aycheck |
|00003a00| 42 72 65 61 6b 64 6f 77 | 6e 2c 20 28 72 6f 77 73 |Breakdow|n, (rows|
|00003a10| 20 6f 6e 65 2d 68 75 6e | 64 72 65 64 2d 66 6f 72 | one-hun|dred-for|
|00003a20| 74 79 2d 6e 69 6e 65 20 | 28 31 34 39 29 20 74 68 |ty-nine |(149) th|
|00003a30| 72 6f 75 67 68 20 6f 6e | 65 2d 68 75 6e 64 72 65 |rough on|e-hundre|
|00003a40| 64 2d 66 69 66 74 79 2d | 66 6f 75 72 20 28 31 35 |d-fifty-|four (15|
|00003a50| 34 29 29 2e 20 20 44 65 | 63 69 73 69 6f 6e 20 41 |4)). De|cision A|
|00003a60| 72 65 61 20 66 6f 72 20 | 68 6f 77 20 6d 75 63 68 |rea for |how much|
|00003a70| 20 24 24 20 74 6f 20 44 | 45 50 4f 53 49 54 2c 20 | $$ to D|EPOSIT, |
|00003a80| 61 6e 64 20 68 6f 77 20 | 6d 75 63 68 20 43 41 53 |and how |much CAS|
|00003a90| 48 2d 4f 4e 2d 48 41 4e | 44 20 77 69 6c 6c 20 62 |H-ON-HAN|D will b|
|00003aa0| 65 20 6e 65 65 64 65 64 | 20 65 61 63 68 20 77 65 |e needed| each we|
|00003ab0| 65 6b 2e 20 49 66 20 79 | 6f 75 20 6d 61 72 6b 20 |ek. If y|ou mark |
|00003ac0| 63 65 72 74 61 69 6e 20 | 63 61 74 65 67 6f 72 79 |certain |category|
|00003ad0| 20 74 69 74 6c 65 73 20 | 61 73 20 28 24 24 29 2c | titles |as ($$),|
|00003ae0| 20 70 61 69 64 20 62 79 | 20 63 61 73 68 20 6f 6e | paid by| cash on|
|00003af0| 6c 79 2c 20 61 6e 64 20 | 28 2d 29 20 70 61 79 20 |ly, and |(-) pay |
|00003b00| 64 65 64 75 63 74 69 6f | 6e 73 2c 20 61 6e 64 20 |deductio|ns, and |
|00003b10| 74 68 65 6e 20 62 75 69 | 6c 64 20 61 20 66 6f 72 |then bui|ld a for|
|00003b20| 6d 75 6c 61 20 77 69 74 | 68 20 74 68 69 73 20 69 |mula wit|h this i|
|00003b30| 6e 20 6d 69 6e 64 2c 20 | 79 6f 75 20 77 69 6c 6c |n mind, |you will|
|00003b40| 20 62 65 20 61 62 6c 65 | 20 74 6f 20 63 61 6c 63 | be able| to calc|
|00003b50| 75 6c 61 74 65 20 62 65 | 66 6f 72 65 68 61 6e 64 |ulate be|forehand|
|00003b60| 2c 20 6e 65 74 20 70 61 | 79 2c 20 61 6e 64 20 68 |, net pa|y, and h|
|00003b70| 6f 77 20 74 6f 20 64 69 | 73 74 72 69 62 75 74 65 |ow to di|stribute|
|00003b80| 20 79 6f 75 72 20 70 61 | 79 63 68 65 63 6b 28 73 | your pa|ycheck(s|
|00003b90| 29 2e 0d 0d 20 20 20 20 | 20 20 20 20 20 20 20 20 |)... | |
|00003ba0| 54 48 49 53 20 41 52 45 | 41 20 41 4e 44 20 49 54 |THIS ARE|A AND IT|
|00003bb0| 53 27 20 56 41 4c 55 45 | 53 20 44 4f 20 4e 4f 54 |S' VALUE|S DO NOT|
|00003bc0| 20 41 44 44 20 49 4e 54 | 4f 20 54 48 45 20 45 58 | ADD INT|O THE EX|
|00003bd0| 50 45 4e 53 45 20 54 4f | 54 41 4c 20 0d 0d 54 68 |PENSE TO|TAL ..Th|
|00003be0| 65 20 66 6f 72 6d 75 6c | 61 73 20 49 20 75 73 65 |e formul|as I use|
|00003bf0| 20 74 61 6b 65 20 74 68 | 65 20 70 61 69 6e 20 6f | take th|e pain o|
|00003c00| 75 74 20 6f 66 20 6e 65 | 65 64 6c 65 73 73 20 72 |ut of ne|edless r|
|00003c10| 65 70 65 74 69 74 69 6f | 6e 2e 20 45 76 65 6e 20 |epetitio|n. Even |
|00003c20| 77 69 74 68 20 61 6e 20 | 6f 64 64 20 69 74 65 6d |with an |odd item|
|00003c30| 20 6f 72 20 74 77 6f 20 | 74 68 61 74 20 6e 65 65 | or two |that nee|
|00003c40| 64 73 20 74 6f 20 62 65 | 20 61 64 64 65 64 20 74 |ds to be| added t|
|00003c50| 6f 20 63 61 73 68 20 6f | 72 20 64 65 64 75 63 74 |o cash o|r deduct|
|00003c60| 65 64 20 66 72 6f 6d 20 | 70 61 79 2c 20 74 68 69 |ed from |pay, thi|
|00003c70| 73 20 61 72 65 61 20 77 | 69 6c 6c 20 68 61 6e 64 |s area w|ill hand|
|00003c80| 6c 65 20 69 74 20 66 6f | 72 20 79 6f 75 20 6f 6e |le it fo|r you on|
|00003c90| 20 61 20 62 69 77 65 65 | 6b 6c 79 20 62 61 73 69 | a biwee|kly basi|
|00003ca0| 73 2e 20 20 44 6f 6e 27 | 74 20 79 6f 75 20 6a 75 |s. Don'|t you ju|
|00003cb0| 73 74 20 68 61 74 65 20 | 66 69 67 75 72 69 6e 67 |st hate |figuring|
|00003cc0| 20 6f 75 74 20 74 68 65 | 20 73 6d 61 6c 6c 20 73 | out the| small s|
|00003cd0| 74 75 66 66 20 2d 20 48 | 6f 77 20 6d 75 63 68 20 |tuff - H|ow much |
|00003ce0| 73 68 6f 75 6c 64 20 49 | 20 64 65 70 6f 73 69 74 |should I| deposit|
|00003cf0| 3f 20 2d 20 48 6f 77 20 | 6d 75 63 68 20 63 61 73 |? - How |much cas|
|00003d00| 68 20 64 6f 20 49 20 6e | 65 65 64 3f 20 2d 20 49 |h do I n|eed? - I|
|00003d10| 73 20 6d 79 20 70 61 79 | 63 68 65 63 6b 28 73 29 |s my pay|check(s)|
|00003d20| 20 73 6d 61 6c 6c 65 72 | 2f 6c 61 72 67 65 72 3f | smaller|/larger?|
|00003d30| 20 20 50 6c 65 61 73 65 | 20 67 69 76 65 20 74 68 | Please| give th|
|00003d40| 69 73 20 61 72 65 61 20 | 73 6f 6d 65 20 74 68 6f |is area |some tho|
|00003d50| 75 67 68 74 20 62 65 66 | 6f 72 65 20 64 69 73 72 |ught bef|ore disr|
|00003d60| 65 67 61 72 64 69 6e 67 | 20 69 74 73 27 20 76 61 |egarding| its' va|
|00003d70| 6c 75 65 2e 20 20 54 72 | 75 73 74 20 6d 65 20 2d |lue. Tr|ust me -|
|00003d80| 20 59 6f 75 27 6c 6c 20 | 62 65 20 67 6c 61 64 20 | You'll |be glad |
|00003d90| 79 6f 75 20 64 69 64 21 | 21 0d 0d a5 20 54 6f 74 |you did!|!... Tot|
|00003da0| 61 6c 20 45 78 70 65 6e | 73 65 73 2c 20 28 72 6f |al Expen|ses, (ro|
|00003db0| 77 20 6f 6e 65 2d 68 75 | 6e 64 72 65 64 2d 66 69 |w one-hu|ndred-fi|
|00003dc0| 66 74 79 2d 73 69 78 20 | 28 31 35 36 29 29 2e 20 |fty-six |(156)). |
|00003dd0| 59 6f 75 20 6d 61 79 20 | 68 61 76 65 20 6e 6f 74 |You may |have not|
|00003de0| 69 63 65 64 20 74 68 61 | 74 20 61 6c 6c 20 66 6f |iced tha|t all fo|
|00003df0| 72 6d 75 6c 61 73 20 61 | 72 65 20 63 6f 6d 70 6f |rmulas a|re compo|
|00003e00| 73 65 64 20 6f 66 20 4e | 61 6d 65 64 20 52 61 6e |sed of N|amed Ran|
|00003e10| 67 65 73 2c 20 69 66 20 | 6e 6f 74 2c 20 69 74 20 |ges, if |not, it |
|00003e20| 64 6f 65 73 6e 27 74 20 | 6d 61 74 74 65 72 2e 20 |doesn't |matter. |
|00003e30| 20 49 20 6a 75 73 74 20 | 77 61 6e 74 65 64 20 74 | I just |wanted t|
|00003e40| 6f 20 6d 65 6e 74 69 6f | 6e 20 74 68 61 74 20 61 |o mentio|n that a|
|00003e50| 6c 6c 20 66 6f 72 6d 75 | 6c 61 73 2c 20 41 4c 4c |ll formu|las, ALL|
|00003e60| 20 46 4f 52 4d 55 4c 41 | 53 2c 20 77 69 6c 6c 20 | FORMULA|S, will |
|00003e70| 61 64 6a 75 73 74 20 74 | 6f 20 77 68 61 74 20 79 |adjust t|o what y|
|00003e80| 6f 75 20 64 6f 20 2d 20 | 61 64 64 20 72 6f 77 28 |ou do - |add row(|
|00003e90| 73 29 3b 20 64 65 6c 65 | 74 65 20 72 6f 77 28 73 |s); dele|te row(s|
|00003ea0| 29 3b 20 65 78 63 65 70 | 74 20 6f 66 20 63 6f 75 |); excep|t of cou|
|00003eb0| 72 73 65 2c 20 63 75 74 | 20 61 6e 64 20 70 61 73 |rse, cut| and pas|
|00003ec0| 74 65 20 72 6f 77 28 73 | 29 2e 20 49 66 20 79 6f |te row(s|). If yo|
|00003ed0| 75 20 77 65 72 65 20 6e | 6f 74 20 63 61 72 65 66 |u were n|ot caref|
|00003ee0| 75 6c 2c 20 74 68 69 73 | 20 6c 61 73 74 20 70 72 |ul, this| last pr|
|00003ef0| 6f 63 65 64 75 72 65 20 | 6d 69 67 68 74 20 63 61 |ocedure |might ca|
|00003f00| 75 73 65 20 61 20 63 69 | 72 63 75 6c 61 72 20 72 |use a ci|rcular r|
|00003f10| 65 66 65 72 65 6e 63 65 | 2e 20 48 75 6e 74 69 6e |eference|. Huntin|
|00003f20| 67 20 66 6f 72 20 74 68 | 6f 73 65 20 61 72 65 20 |g for th|ose are |
|00003f30| 61 20 73 63 72 65 61 6d | 2e 20 42 79 20 75 73 69 |a scream|. By usi|
|00003f40| 6e 67 20 66 6f 72 6d 75 | 6c 61 73 20 77 69 74 68 |ng formu|las with|
|00003f50| 20 64 65 66 69 6e 65 64 | 20 6e 61 6d 65 73 2c 20 | defined| names, |
|00003f60| 63 6f 6e 73 74 72 75 63 | 74 69 6f 6e 20 77 61 73 |construc|tion was|
|00003f70| 20 65 61 73 69 65 72 2e | 20 54 68 69 73 20 61 6c | easier.| This al|
|00003f80| 6c 6f 77 65 64 20 6d 65 | 20 74 6f 20 6d 61 6b 65 |lowed me| to make|
|00003f90| 20 73 75 72 65 20 74 68 | 61 74 20 74 68 65 20 6e | sure th|at the n|
|00003fa0| 6f 6e 2d 63 65 6c 6c 73 | 20 28 64 61 74 65 73 2c |on-cells| (dates,|
|00003fb0| 20 61 6e 64 20 63 61 74 | 65 67 6f 72 79 20 74 69 | and cat|egory ti|
|00003fc0| 74 6c 65 73 29 20 64 69 | 64 20 6e 6f 74 20 61 64 |tles) di|d not ad|
|00003fd0| 64 20 69 6e 74 6f 20 65 | 78 70 65 6e 73 65 73 2e |d into e|xpenses.|
|00003fe0| 20 20 54 68 65 20 72 65 | 73 75 6c 74 73 20 77 6f | The re|sults wo|
|00003ff0| 75 6c 64 20 68 61 76 65 | 20 62 65 65 6e 20 64 69 |uld have| been di|
|00004000| 73 61 73 74 72 6f 75 73 | 2e 20 20 0d 0d a5 20 43 |sastrous|. ... C|
|00004010| 61 72 72 79 20 74 6f 20 | 4e 65 78 74 20 42 69 57 |arry to |Next BiW|
|00004020| 65 65 6b 2c 20 28 72 6f | 77 20 6f 6e 65 2d 68 75 |eek, (ro|w one-hu|
|00004030| 6e 64 72 65 64 2d 66 69 | 66 74 79 2d 65 69 67 68 |ndred-fi|fty-eigh|
|00004040| 74 20 28 31 35 38 29 29 | 2e 20 54 68 69 73 20 69 |t (158))|. This i|
|00004050| 73 20 74 72 61 6e 73 66 | 65 72 72 65 64 20 74 6f |s transf|erred to|
|00004060| 20 74 68 65 20 6e 65 78 | 74 20 62 69 77 65 65 6b | the nex|t biweek|
|00004070| 6c 79 20 69 6e 63 6f 6d | 65 2c 20 28 72 6f 77 20 |ly incom|e, (row |
|00004080| 66 69 66 74 65 65 6e 20 | 28 31 35 29 29 2e 20 0d |fifteen |(15)). .|
|00004090| 0d 20 20 20 20 20 20 20 | 20 20 55 4e 44 45 52 20 |. | UNDER |
|000040a0| 4e 4f 20 43 49 52 43 55 | 4d 53 54 41 4e 43 45 53 |NO CIRCU|MSTANCES|
|000040b0| 20 44 45 4c 45 54 45 20 | 54 48 45 20 46 4f 4c 4c | DELETE |THE FOLL|
|000040c0| 4f 57 49 4e 47 20 41 52 | 45 41 0d 20 0d a5 20 43 |OWING AR|EA. .. C|
|000040d0| 6f 6e 76 65 72 73 69 6f | 6e 20 41 72 65 61 20 66 |onversio|n Area f|
|000040e0| 6f 72 20 4c 69 6e 6b 69 | 6e 67 20 2d 20 56 45 52 |or Linki|ng - VER|
|000040f0| 59 20 45 53 53 45 4e 54 | 49 41 4c 2c 20 28 72 6f |Y ESSENT|IAL, (ro|
|00004100| 77 73 20 6f 6e 65 2d 68 | 75 6e 64 72 65 64 2d 73 |ws one-h|undred-s|
|00004110| 69 78 74 79 20 28 31 36 | 30 29 20 74 68 72 6f 75 |ixty (16|0) throu|
|00004120| 67 68 20 6f 6e 65 2d 68 | 75 6e 64 72 65 64 2d 73 |gh one-h|undred-s|
|00004130| 69 78 74 79 2d 66 6f 75 | 72 20 28 31 36 34 29 29 |ixty-fou|r (164))|
|00004140| 2e 20 46 72 6f 6d 20 74 | 68 69 73 20 61 72 65 61 |. From t|his area|
|00004150| 2c 20 65 61 63 68 20 62 | 69 77 65 65 6b 20 69 73 |, each b|iweek is|
|00004160| 20 61 73 73 69 67 6e 65 | 64 20 74 6f 20 74 68 65 | assigne|d to the|
|00004170| 20 63 6f 72 72 65 63 74 | 20 6d 6f 6e 74 68 20 69 | correct| month i|
|00004180| 6e 20 74 68 65 20 63 75 | 72 72 65 6e 74 20 62 75 |n the cu|rrent bu|
|00004190| 64 67 65 74 20 79 65 61 | 72 2e 20 54 68 69 73 20 |dget yea|r. This |
|000041a0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 20 69 73 20 74 |informat|ion is t|
|000041b0| 68 65 6e 20 74 72 61 6e | 73 66 65 72 72 65 64 20 |hen tran|sferred |
|000041c0| 74 6f 20 74 68 65 20 4d | 41 49 4e 20 4c 49 4e 4b |to the M|AIN LINK|
|000041d0| 49 4e 47 20 41 52 45 41 | 2e 20 57 69 74 68 20 74 |ING AREA|. With t|
|000041e0| 68 69 73 20 69 6e 66 6f | 72 6d 61 74 69 6f 6e 2c |his info|rmation,|
|000041f0| 20 79 6f 75 20 63 61 6e | 20 74 68 65 6e 20 63 6f | you can| then co|
|00004200| 6e 73 74 72 75 63 74 20 | 74 68 65 20 74 77 65 6c |nstruct |the twel|
|00004210| 76 65 20 66 6f 72 6d 75 | 6c 61 73 20 6e 65 65 64 |ve formu|las need|
|00004220| 65 64 20 66 6f 72 20 74 | 68 65 20 6c 69 6e 6b 69 |ed for t|he linki|
|00004230| 6e 67 20 61 72 65 61 2e | 20 20 54 68 65 20 64 69 |ng area.| The di|
|00004240| 61 6c 6f 67 20 62 6f 78 | 20 69 6e 73 74 72 75 63 |alog box| instruc|
|00004250| 74 69 6f 6e 73 20 69 6e | 20 74 68 61 74 20 61 72 |tions in| that ar|
|00004260| 65 61 20 77 69 6c 6c 20 | 6d 61 6b 65 20 74 68 69 |ea will |make thi|
|00004270| 73 20 72 65 6c 61 74 69 | 76 65 6c 79 20 70 61 69 |s relati|vely pai|
|00004280| 6e 6c 65 73 73 2e 0d 20 | 0d a5 20 45 6c 65 63 74 |nless.. |.. Elect|
|00004290| 72 69 63 20 55 74 69 6c | 69 74 69 65 73 20 43 61 |ric Util|ities Ca|
|000042a0| 6c 63 75 6c 61 74 69 6f | 6e 20 41 72 65 61 2c 20 |lculatio|n Area, |
|000042b0| 28 72 6f 77 73 20 6f 6e | 65 2d 68 75 6e 64 72 65 |(rows on|e-hundre|
|000042c0| 64 2d 73 69 78 74 79 2d | 73 69 78 20 28 31 36 36 |d-sixty-|six (166|
|000042d0| 29 20 74 68 72 6f 75 67 | 68 20 0d 6f 6e 65 2d 68 |) throug|h .one-h|
|000042e0| 75 6e 64 72 65 64 2d 73 | 65 76 65 6e 74 79 2d 65 |undred-s|eventy-e|
|000042f0| 69 67 68 74 20 28 31 37 | 38 29 29 2e 20 20 49 20 |ight (17|8)). I |
|00004300| 72 65 61 6c 69 7a 65 20 | 74 68 61 74 20 79 6f 75 |realize |that you|
|00004310| 72 20 61 72 65 61 27 73 | 20 65 6c 65 63 74 72 69 |r area's| electri|
|00004320| 63 61 6c 20 72 61 74 65 | 73 20 77 69 6c 6c 20 62 |cal rate|s will b|
|00004330| 65 20 64 69 66 66 65 72 | 65 6e 74 20 74 68 61 6e |e differ|ent than|
|00004340| 20 74 68 65 20 6f 6e 65 | 20 6c 69 73 74 65 64 2c | the one| listed,|
|00004350| 20 62 75 74 20 77 69 74 | 68 20 73 6f 6d 65 20 63 | but wit|h some c|
|00004360| 68 61 6e 67 65 73 20 69 | 6e 20 74 68 65 20 66 6f |hanges i|n the fo|
|00004370| 72 6d 75 6c 61 20 6f 6e | 20 59 4f 55 52 20 50 41 |rmula on| YOUR PA|
|00004380| 52 54 2c 20 79 6f 75 20 | 73 68 6f 75 6c 64 20 62 |RT, you |should b|
|00004390| 65 20 61 62 6c 65 20 74 | 6f 20 64 65 76 69 73 65 |e able t|o devise|
|000043a0| 20 61 20 77 6f 72 6b 61 | 62 6c 65 20 66 6f 72 6d | a worka|ble form|
|000043b0| 75 6c 61 2e 20 20 59 6f | 75 20 63 61 6e 20 75 73 |ula. Yo|u can us|
|000043c0| 65 20 74 68 69 73 20 74 | 6f 20 62 75 64 67 65 74 |e this t|o budget|
|000043d0| 20 79 6f 75 72 20 6d 6f | 6e 74 68 6c 79 20 65 6c | your mo|nthly el|
|000043e0| 65 63 74 72 69 63 20 75 | 73 61 67 65 2e 20 49 66 |ectric u|sage. If|
|000043f0| 20 79 6f 75 20 6e 65 65 | 64 20 73 6f 6d 65 20 68 | you nee|d some h|
|00004400| 65 6c 70 2c 20 6a 75 73 | 74 20 45 2d 6d 61 69 6c |elp, jus|t E-mail|
|00004410| 20 6d 65 20 28 76 69 61 | 20 20 41 4f 4c 20 44 41 | me (via| AOL DA|
|00004420| 56 49 44 45 4f 35 34 30 | 29 2e 20 49 66 20 79 6f |VIDEO540|). If yo|
|00004430| 75 20 68 61 76 65 20 79 | 6f 75 72 20 28 65 6c 65 |u have y|our (ele|
|00004440| 63 74 72 69 63 20 75 74 | 69 6c 69 74 69 65 73 29 |ctric ut|ilities)|
|00004450| 20 70 72 65 76 69 6f 75 | 73 20 79 65 61 72 73 20 | previou|s years |
|00004460| 64 61 74 61 2c 20 66 6f | 72 65 63 61 73 74 69 6e |data, fo|recastin|
|00004470| 67 20 73 68 6f 75 6c 64 | 20 62 65 20 6d 75 63 68 |g should| be much|
|00004480| 20 73 69 6d 70 6c 65 72 | 2e 0d 0d a5 20 47 4f 20 | simpler|.... GO |
|00004490| 55 54 49 4c 53 20 62 75 | 74 74 6f 6e 2c 20 28 72 |UTILS bu|tton, (r|
|000044a0| 6f 77 73 20 6f 6e 65 2d | 68 75 6e 64 72 65 64 2d |ows one-|hundred-|
|000044b0| 73 65 76 65 6e 74 79 2d | 74 68 72 65 65 20 28 31 |seventy-|three (1|
|000044c0| 37 33 29 20 2d 20 63 65 | 6c 6c 20 28 43 36 29 2e |73) - ce|ll (C6).|
|000044d0| 20 54 68 69 73 20 62 75 | 74 74 6f 6e 20 77 69 6c | This bu|tton wil|
|000044e0| 6c 20 72 65 74 75 72 6e | 20 79 6f 75 20 74 6f 20 |l return| you to |
|000044f0| 74 68 65 20 62 75 64 67 | 65 74 69 6e 67 20 61 72 |the budg|eting ar|
|00004500| 65 61 2c 20 73 6f 20 74 | 68 61 74 20 79 6f 75 20 |ea, so t|hat you |
|00004510| 6d 61 79 20 65 6e 74 65 | 72 20 79 6f 75 72 20 65 |may ente|r your e|
|00004520| 73 74 69 6d 61 74 65 64 | 20 65 6c 65 63 74 72 69 |stimated| electri|
|00004530| 63 20 75 74 69 6c 69 74 | 79 20 76 61 6c 75 65 2e |c utilit|y value.|
|00004540| 20 46 72 61 6e 6b 6c 79 | 2c 20 68 61 70 68 61 7a | Frankly|, haphaz|
|00004550| 61 72 64 20 73 63 72 6f | 6c 6c 69 6e 67 2c 20 61 |ard scro|lling, a|
|00004560| 6e 64 20 73 65 61 72 63 | 68 20 61 6e 64 20 66 69 |nd searc|h and fi|
|00004570| 6e 64 20 61 72 65 20 66 | 6f 72 20 74 68 65 20 62 |nd are f|or the b|
|00004580| 69 72 64 73 2e 0d 0d a5 | 20 5a 6f 6e 65 20 6f 66 |irds....| Zone of|
|00004590| 20 41 76 6f 69 64 61 6e | 63 65 2c 20 6f 72 20 4e | Avoidan|ce, or N|
|000045a0| 6f 20 44 61 74 61 20 45 | 6e 74 72 79 20 5a 6f 6e |o Data E|ntry Zon|
|000045b0| 65 2c 20 28 72 6f 77 20 | 6f 6e 65 2d 68 75 6e 64 |e, (row |one-hund|
|000045c0| 72 65 64 2d 65 69 67 68 | 74 79 2d 66 6f 75 72 20 |red-eigh|ty-four |
|000045d0| 28 31 38 34 29 29 2e 20 | 4a 75 73 74 20 62 65 6c |(184)). |Just bel|
|000045e0| 6f 77 20 74 68 65 20 45 | 6c 65 63 74 72 69 63 20 |ow the E|lectric |
|000045f0| 55 74 69 6c 69 74 79 20 | 61 72 65 61 2c 20 69 73 |Utility |area, is|
|00004600| 20 74 68 65 20 64 61 6e | 67 65 72 20 7a 6f 6e 65 | the dan|ger zone|
|00004610| 20 77 68 65 72 65 20 61 | 6e 79 20 64 61 74 61 20 | where a|ny data |
|00004620| 65 6e 74 65 72 65 64 20 | 77 69 6c 6c 20 44 49 53 |entered |will DIS|
|00004630| 41 50 50 45 41 52 2e 20 | 20 54 68 65 20 61 62 6f |APPEAR. | The abo|
|00004640| 76 65 20 6d 65 6e 74 69 | 6f 6e 65 64 20 72 6f 77 |ve menti|oned row|
|00004650| 20 69 73 20 68 69 67 68 | 6c 69 67 68 74 65 64 20 | is high|lighted |
|00004660| 69 6e 20 79 65 6c 6c 6f | 77 20 74 6f 20 77 61 72 |in yello|w to war|
|00004670| 6e 20 79 6f 75 20 6f 66 | 20 74 68 69 73 2e 20 53 |n you of| this. S|
|00004680| 6f 72 72 79 20 61 62 6f | 75 74 20 74 68 65 20 6e |orry abo|ut the n|
|00004690| 61 6d 65 20 2d 20 74 6f | 6f 20 6d 75 63 68 20 4e |ame - to|o much N|
|000046a0| 69 6e 74 65 6e 64 6f 20 | 77 69 74 68 20 74 68 65 |intendo |with the|
|000046b0| 20 62 6f 79 73 2c 20 49 | 20 67 75 65 73 73 2e 20 | boys, I| guess. |
|000046c0| 41 6e 79 20 66 6f 72 6d | 75 6c 61 73 20 6f 72 20 |Any form|ulas or |
|000046d0| 75 6e 69 71 75 65 20 74 | 61 62 6c 65 73 20 74 68 |unique t|ables th|
|000046e0| 61 74 20 79 6f 75 20 6d | 61 79 20 63 72 65 61 74 |at you m|ay creat|
|000046f0| 65 20 63 61 6e 20 65 69 | 74 68 65 72 20 62 65 20 |e can ei|ther be |
|00004700| 73 74 6f 72 65 64 20 74 | 6f 20 74 68 65 20 72 69 |stored t|o the ri|
|00004710| 67 68 74 20 6f 66 20 74 | 68 65 20 45 6c 65 63 74 |ght of t|he Elect|
|00004720| 72 69 63 20 55 74 69 6c | 69 74 69 65 73 20 43 61 |ric Util|ities Ca|
|00004730| 6c 63 75 6c 61 74 69 6f | 6e 20 41 72 65 61 2c 20 |lculatio|n Area, |
|00004740| 6f 72 20 74 6f 20 74 68 | 65 20 72 69 67 68 74 20 |or to th|e right |
|00004750| 6f 66 20 74 68 65 20 50 | 72 69 6e 74 20 41 72 65 |of the P|rint Are|
|00004760| 61 20 66 6f 72 20 68 61 | 72 64 20 63 6f 70 69 65 |a for ha|rd copie|
|00004770| 73 2e 20 54 72 79 20 73 | 74 6f 72 69 6e 67 20 72 |s. Try s|toring r|
|00004780| 65 6c 61 74 65 64 20 64 | 61 74 61 20 69 6e 20 74 |elated d|ata in t|
|00004790| 68 65 20 77 6f 72 6b 62 | 6f 6f 6b 2c 20 74 6f 20 |he workb|ook, to |
|000047a0| 6b 65 65 70 20 74 68 65 | 20 6d 65 6d 6f 72 79 20 |keep the| memory |
|000047b0| 73 69 7a 65 20 6f 66 20 | 74 68 65 20 4e 45 57 20 |size of |the NEW |
|000047c0| 57 4f 52 4b 53 48 45 45 | 54 20 64 6f 77 6e 2e 0d |WORKSHEE|T down..|
|000047d0| 20 0d a5 20 54 68 65 20 | 50 72 69 6e 74 20 41 72 | .. The |Print Ar|
|000047e0| 65 61 20 66 6f 72 20 68 | 61 72 64 20 63 6f 70 69 |ea for h|ard copi|
|000047f0| 65 73 2c 20 28 72 6f 77 | 73 20 6f 6e 65 20 28 31 |es, (row|s one (1|
|00004800| 29 20 74 68 72 6f 75 67 | 68 20 74 68 72 65 65 2d |) throug|h three-|
|00004810| 68 75 6e 64 72 65 64 2d | 66 6f 72 74 79 2d 66 69 |hundred-|forty-fi|
|00004820| 76 65 20 28 33 34 35 29 | 29 2e 20 54 68 69 73 20 |ve (345)|). This |
|00004830| 72 61 6e 67 65 20 69 73 | 20 64 69 76 69 64 65 64 |range is| divided|
|00004840| 20 69 6e 74 6f 20 74 77 | 6f 20 73 65 70 61 72 61 | into tw|o separa|
|00004850| 74 65 20 61 72 65 61 73 | 3a 20 0d 0d 31 2e 20 54 |te areas|: ..1. T|
|00004860| 68 65 20 52 4f 55 47 48 | 20 50 52 49 4e 54 20 61 |he ROUGH| PRINT a|
|00004870| 72 65 61 2c 20 28 72 6f | 77 73 20 6f 6e 65 20 28 |rea, (ro|ws one (|
|00004880| 31 29 20 74 68 72 6f 75 | 67 68 20 6f 6e 65 2d 68 |1) throu|gh one-h|
|00004890| 75 6e 64 72 65 64 2d 73 | 69 78 74 79 2d 73 69 78 |undred-s|ixty-six|
|000048a0| 20 28 31 36 36 29 29 2c | 20 77 68 69 63 68 20 77 | (166)),| which w|
|000048b0| 69 6c 6c 20 67 69 76 65 | 20 79 6f 75 20 61 20 71 |ill give| you a q|
|000048c0| 75 69 63 6b 65 72 20 70 | 72 69 6e 74 6f 75 74 2e |uicker p|rintout.|
|000048d0| 0d 0d 32 2e 20 54 68 65 | 20 46 49 4e 41 4c 20 50 |..2. The| FINAL P|
|000048e0| 52 49 4e 54 20 61 72 65 | 61 2c 20 28 72 6f 77 73 |RINT are|a, (rows|
|000048f0| 20 6f 6e 65 2d 68 75 6e | 64 72 65 64 2d 73 65 76 | one-hun|dred-sev|
|00004900| 65 6e 74 79 2d 65 69 67 | 68 74 20 28 31 37 38 29 |enty-eig|ht (178)|
|00004910| 20 74 68 72 6f 75 67 68 | 20 74 68 72 65 65 2d 68 | through| three-h|
|00004920| 75 6e 64 72 65 64 2d 66 | 6f 72 74 79 2d 66 69 76 |undred-f|orty-fiv|
|00004930| 65 20 28 33 34 35 29 29 | 2c 20 77 68 69 63 68 20 |e (345))|, which |
|00004940| 77 69 6c 6c 20 63 72 65 | 61 74 65 20 61 20 63 6c |will cre|ate a cl|
|00004950| 65 61 6e 20 6c 6f 6f 6b | 69 6e 67 20 63 6f 6d 70 |ean look|ing comp|
|00004960| 72 65 73 73 65 64 20 70 | 72 69 6e 74 6f 75 74 20 |ressed p|rintout |
|00004970| 66 6f 72 20 66 69 6c 69 | 6e 67 20 70 75 72 70 6f |for fili|ng purpo|
|00004980| 73 65 73 2e 0d 20 0d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |ses.. .-|--------|
|00004990| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000049a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000049b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000049c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000049d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000049e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000049f0| 2d 2d 2d 0d 0d 54 68 65 | 20 27 4e 45 57 20 57 4f |---..The| 'NEW WO|
|00004a00| 52 4b 53 48 45 45 54 27 | 20 61 6c 73 6f 20 68 61 |RKSHEET'| also ha|
|00004a10| 73 20 6c 6f 63 61 74 69 | 6f 6e 73 20 74 68 61 74 |s locati|ons that|
|00004a20| 20 6e 65 65 64 20 74 6f | 20 62 65 20 6d 65 6e 74 | need to| be ment|
|00004a30| 69 6f 6e 65 64 20 62 79 | 20 63 6f 6c 75 6d 6e 2e |ioned by| column.|
|00004a40| 0d 0d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |..------|--------|
|00004a50| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004a60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004a70| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004a80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004a90| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004aa0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 0d 0d |--------|------..|
|00004ab0| 0d 20 20 20 20 20 20 20 | 44 45 4c 45 54 45 20 4e |. |DELETE N|
|00004ac0| 4f 20 43 4f 4c 55 4d 4e | 53 20 55 4e 44 45 52 20 |O COLUMN|S UNDER |
|00004ad0| 41 4e 59 20 43 49 52 43 | 55 4d 53 54 41 4e 43 45 |ANY CIRC|UMSTANCE|
|00004ae0| 0d 0d 0d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |...-----|--------|
|00004af0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004b00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004b10| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004b20| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004b30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004b40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 0d |--------|-------.|
|00004b50| 0d a5 20 43 6f 6c 75 6d | 6e 73 20 41 20 26 20 41 |.. Colum|ns A & A|
|00004b60| 46 20 20 2d 20 54 68 69 | 73 20 69 73 20 77 68 65 |F - Thi|s is whe|
|00004b70| 72 65 20 73 6f 6d 65 20 | 6d 6f 76 65 6d 65 6e 74 |re some |movement|
|00004b80| 20 28 77 61 72 70 20 74 | 6f 29 20 62 75 74 74 6f | (warp t|o) butto|
|00004b90| 6e 73 20 61 72 65 20 6c | 6f 63 61 74 65 64 2e 20 |ns are l|ocated. |
|00004ba0| 54 68 65 20 66 69 72 73 | 74 20 66 6f 75 72 20 62 |The firs|t four b|
|00004bb0| 75 74 74 6f 6e 73 20 61 | 72 65 20 74 68 65 20 66 |uttons a|re the f|
|00004bc0| 6f 75 72 20 63 6f 72 6e | 65 72 73 20 6f 66 20 74 |our corn|ers of t|
|00004bd0| 68 65 20 64 61 74 61 20 | 65 6e 74 72 79 20 61 72 |he data |entry ar|
|00004be0| 65 61 2e 20 4b 65 79 20 | 61 72 65 61 73 20 61 72 |ea. Key |areas ar|
|00004bf0| 65 20 61 76 61 69 6c 61 | 62 6c 65 20 66 72 6f 6d |e availa|ble from|
|00004c00| 20 61 6c 6c 20 6c 6f 63 | 61 74 69 6f 6e 73 2e 20 | all loc|ations. |
|00004c10| 0d 20 0d 31 2e 20 42 52 | 20 2d 20 54 68 69 73 20 |. .1. BR| - This |
|00004c20| 62 75 74 74 6f 6e 20 77 | 69 6c 6c 20 74 61 6b 65 |button w|ill take|
|00004c30| 20 79 6f 75 20 74 6f 20 | 74 68 65 20 62 6f 74 74 | you to |the bott|
|00004c40| 6f 6d 20 72 69 67 68 74 | 20 6f 66 20 74 68 65 20 |om right| of the |
|00004c50| 64 61 74 61 20 65 6e 74 | 72 79 20 61 72 65 61 2e |data ent|ry area.|
|00004c60| 20 59 6f 75 20 77 69 6c | 6c 20 62 65 20 61 62 6c | You wil|l be abl|
|00004c70| 65 20 74 6f 20 76 65 72 | 69 66 79 20 74 68 65 20 |e to ver|ify the |
|00004c80| 65 6e 64 69 6e 67 20 63 | 61 72 72 79 20 61 6d 6f |ending c|arry amo|
|00004c90| 75 6e 74 2c 20 61 6e 64 | 20 74 68 65 20 72 65 6d |unt, and| the rem|
|00004ca0| 61 69 6e 69 6e 67 20 63 | 6f 72 6e 65 72 20 62 75 |aining c|orner bu|
|00004cb0| 74 74 6f 6e 73 20 61 72 | 65 20 61 6c 73 6f 20 61 |ttons ar|e also a|
|00004cc0| 76 61 69 6c 61 62 6c 65 | 20 66 72 6f 6d 20 74 68 |vailable| from th|
|00004cd0| 69 73 20 6c 6f 63 61 74 | 69 6f 6e 2e 20 59 6f 75 |is locat|ion. You|
|00004ce0| 20 77 69 6c 6c 20 61 6c | 73 6f 20 62 65 20 61 62 | will al|so be ab|
|00004cf0| 6c 65 20 74 6f 20 73 65 | 6c 65 63 74 20 74 68 65 |le to se|lect the|
|00004d00| 20 77 61 72 70 69 6e 67 | 20 62 75 74 74 6f 6e 73 | warping| buttons|
|00004d10| 20 66 6f 72 20 74 68 65 | 20 53 55 4d 4d 41 52 59 | for the| SUMMARY|
|00004d20| 20 61 6e 64 20 50 52 49 | 4e 54 20 41 52 45 41 53 | and PRI|NT AREAS|
|00004d30| 2e 0d 0d 32 2e 20 42 4c | 20 2d 20 54 68 69 73 20 |...2. BL| - This |
|00004d40| 62 75 74 74 6f 6e 20 77 | 69 6c 6c 20 74 61 6b 65 |button w|ill take|
|00004d50| 20 79 6f 75 20 74 6f 20 | 74 68 65 20 62 6f 74 74 | you to |the bott|
|00004d60| 6f 6d 20 6c 65 66 74 20 | 6f 66 20 74 68 65 20 64 |om left |of the d|
|00004d70| 61 74 61 20 65 6e 74 72 | 79 20 61 72 65 61 2e 20 |ata entr|y area. |
|00004d80| 54 68 65 20 45 6c 65 63 | 74 72 69 63 20 55 74 69 |The Elec|tric Uti|
|00004d90| 6c 69 74 69 65 73 20 61 | 72 65 61 2c 20 61 6e 64 |lities a|rea, and|
|00004da0| 20 4c 69 6e 6b 20 77 61 | 72 70 20 62 75 74 74 6f | Link wa|rp butto|
|00004db0| 6e 73 20 77 69 6c 6c 20 | 62 65 20 61 76 61 69 6c |ns will |be avail|
|00004dc0| 61 62 6c 65 2c 20 61 73 | 20 77 69 74 68 20 61 63 |able, as| with ac|
|00004dd0| 63 65 73 73 20 74 6f 20 | 74 68 65 20 72 65 6d 61 |cess to |the rema|
|00004de0| 69 6e 69 6e 67 20 63 6f | 72 6e 65 72 20 62 75 74 |ining co|rner but|
|00004df0| 74 6f 6e 73 2e 20 59 6f | 75 20 77 69 6c 6c 20 61 |tons. Yo|u will a|
|00004e00| 6c 73 6f 20 62 65 20 61 | 62 6c 65 20 74 6f 20 73 |lso be a|ble to s|
|00004e10| 65 6c 65 63 74 20 74 68 | 65 20 77 61 72 70 69 6e |elect th|e warpin|
|00004e20| 67 20 62 75 74 74 6f 6e | 73 20 66 6f 72 20 74 68 |g button|s for th|
|00004e30| 65 20 53 55 4d 4d 41 52 | 59 20 61 6e 64 20 50 52 |e SUMMAR|Y and PR|
|00004e40| 49 4e 54 20 41 52 45 41 | 53 2e 0d 0d 33 2e 20 55 |INT AREA|S...3. U|
|00004e50| 52 20 2d 20 54 68 69 73 | 20 62 75 74 74 6f 6e 20 |R - This| button |
|00004e60| 77 69 6c 6c 20 74 61 6b | 65 20 79 6f 75 20 74 6f |will tak|e you to|
|00004e70| 20 74 68 65 20 75 70 70 | 65 72 20 72 69 67 68 74 | the upp|er right|
|00004e80| 20 6f 66 20 74 68 65 20 | 64 61 74 61 20 65 6e 74 | of the |data ent|
|00004e90| 72 79 20 61 72 65 61 2e | 20 54 68 65 20 61 72 65 |ry area.| The are|
|00004ea0| 61 20 79 6f 75 20 61 72 | 65 20 74 72 61 6e 73 70 |a you ar|e transp|
|00004eb0| 6f 72 74 65 64 20 74 6f | 20 77 69 6c 6c 20 68 6f |orted to| will ho|
|00004ec0| 6c 64 20 62 69 77 65 65 | 6b 20 74 77 65 6e 74 79 |ld biwee|k twenty|
|00004ed0| 2d 73 65 76 65 6e 20 28 | 32 37 29 2c 20 73 6f 20 |-seven (|27), so |
|00004ee0| 74 68 61 74 20 79 6f 75 | 20 63 61 6e 20 76 65 72 |that you| can ver|
|00004ef0| 69 66 79 20 69 66 20 74 | 68 61 74 20 62 69 77 65 |ify if t|hat biwe|
|00004f00| 65 6b 20 69 73 20 69 6e | 20 74 68 65 20 73 61 6d |ek is in| the sam|
|00004f10| 65 20 62 75 64 67 65 74 | 20 79 65 61 72 2e 20 54 |e budget| year. T|
|00004f20| 69 6d 65 20 62 75 74 74 | 6f 6e 73 2c 20 61 6e 64 |ime butt|ons, and|
|00004f30| 20 74 68 65 20 72 65 6d | 61 69 6e 69 6e 67 20 63 | the rem|aining c|
|00004f40| 6f 72 6e 65 72 20 62 75 | 74 74 6f 6e 73 20 61 72 |orner bu|ttons ar|
|00004f50| 65 20 61 6c 73 6f 20 61 | 76 61 69 6c 61 62 6c 65 |e also a|vailable|
|00004f60| 20 66 72 6f 6d 20 74 68 | 69 73 20 6c 6f 63 61 74 | from th|is locat|
|00004f70| 69 6f 6e 2e 20 59 6f 75 | 20 77 69 6c 6c 20 61 6c |ion. You| will al|
|00004f80| 73 6f 20 62 65 20 61 62 | 6c 65 20 74 6f 20 73 65 |so be ab|le to se|
|00004f90| 6c 65 63 74 20 74 68 65 | 20 77 61 72 70 69 6e 67 |lect the| warping|
|00004fa0| 20 62 75 74 74 6f 6e 73 | 20 66 6f 72 20 74 68 65 | buttons| for the|
|00004fb0| 20 53 55 4d 4d 41 52 59 | 20 61 6e 64 20 50 52 49 | SUMMARY| and PRI|
|00004fc0| 4e 54 20 41 52 45 41 53 | 2e 0d 0d 34 2e 20 55 4c |NT AREAS|...4. UL|
|00004fd0| 20 2d 20 54 68 69 73 20 | 62 75 74 74 6f 6e 20 77 | - This |button w|
|00004fe0| 69 6c 6c 20 74 61 6b 65 | 20 79 6f 75 20 74 6f 20 |ill take| you to |
|00004ff0| 74 68 65 20 75 70 70 65 | 72 20 6c 65 66 74 20 6f |the uppe|r left o|
|00005000| 66 20 74 68 65 20 64 61 | 74 61 20 65 6e 74 72 79 |f the da|ta entry|
|00005010| 20 61 72 65 61 2e 20 54 | 68 65 20 74 77 6f 20 74 | area. T|he two t|
|00005020| 6f 67 67 6c 65 20 73 65 | 74 73 20 66 6f 72 20 73 |oggle se|ts for s|
|00005030| 65 74 74 69 6e 67 20 75 | 70 20 74 68 65 20 6e 65 |etting u|p the ne|
|00005040| 77 20 77 6f 72 6b 73 68 | 65 65 74 20 61 72 65 20 |w worksh|eet are |
|00005050| 69 6e 20 74 68 69 73 20 | 6c 6f 63 61 74 69 6f 6e |in this |location|
|00005060| 2e 20 54 69 6d 65 20 62 | 75 74 74 6f 6e 73 2c 20 |. Time b|uttons, |
|00005070| 61 6e 64 20 74 68 65 20 | 72 65 6d 61 69 6e 69 6e |and the |remainin|
|00005080| 67 20 63 6f 72 6e 65 72 | 20 62 75 74 74 6f 6e 73 |g corner| buttons|
|00005090| 20 61 72 65 20 61 6c 73 | 6f 20 61 76 61 69 6c 61 | are als|o availa|
|000050a0| 62 6c 65 20 66 72 6f 6d | 20 74 68 69 73 20 6c 6f |ble from| this lo|
|000050b0| 63 61 74 69 6f 6e 2e 20 | 59 6f 75 20 77 69 6c 6c |cation. |You will|
|000050c0| 20 61 6c 73 6f 20 62 65 | 20 61 62 6c 65 20 74 6f | also be| able to|
|000050d0| 20 73 65 6c 65 63 74 20 | 74 68 65 20 77 61 72 70 | select |the warp|
|000050e0| 69 6e 67 20 62 75 74 74 | 6f 6e 73 20 66 6f 72 20 |ing butt|ons for |
|000050f0| 74 68 65 20 53 55 4d 4d | 41 52 59 20 61 6e 64 20 |the SUMM|ARY and |
|00005100| 50 52 49 4e 54 20 41 52 | 45 41 53 2e 0d 0d 35 2e |PRINT AR|EAS...5.|
|00005110| 20 47 4f 20 50 52 49 4e | 54 20 2d 20 54 68 69 73 | GO PRIN|T - This|
|00005120| 20 62 75 74 74 6f 6e 20 | 77 69 6c 6c 20 74 61 6b | button |will tak|
|00005130| 65 20 79 6f 75 20 74 6f | 20 74 68 65 20 4d 41 49 |e you to| the MAI|
|00005140| 4e 20 53 45 4c 45 43 54 | 49 4f 4e 20 41 52 45 41 |N SELECT|ION AREA|
|00005150| 20 66 6f 72 20 70 72 69 | 6e 74 69 6e 67 2e 0d 0d | for pri|nting...|
|00005160| a5 20 43 6f 6c 75 6d 6e | 20 43 20 2d 20 54 68 69 |. Column| C - Thi|
|00005170| 73 20 61 72 65 61 20 63 | 6f 6e 74 61 69 6e 73 20 |s area c|ontains |
|00005180| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 62 75 |the foll|owing bu|
|00005190| 74 74 6f 6e 73 3a 0d 0d | 31 2e 20 54 6f 67 67 6c |ttons:..|1. Toggl|
|000051a0| 65 20 62 75 74 74 6f 6e | 73 3a 20 28 6f 6e 65 20 |e button|s: (one |
|000051b0| 62 75 74 74 6f 6e 20 69 | 73 20 6f 6e 20 74 6f 70 |button i|s on top|
|000051c0| 20 6f 66 20 61 6e 6f 74 | 68 65 72 20 62 75 74 74 | of anot|her butt|
|000051d0| 6f 6e 29 0d 0d 61 29 20 | 53 45 54 20 41 4c 4c 20 |on)..a) |SET ALL |
|000051e0| 43 45 4c 4c 20 54 4f 3f | 3f 20 2d 20 54 68 69 73 |CELL TO?|? - This|
|000051f0| 20 62 75 74 74 6f 6e 20 | 61 6c 6c 6f 77 73 20 79 | button |allows y|
|00005200| 6f 75 20 74 6f 20 63 6c | 65 61 72 20 6f 72 20 73 |ou to cl|ear or s|
|00005210| 65 74 20 74 6f 20 61 6e | 79 20 76 61 6c 75 65 2c |et to an|y value,|
|00005220| 20 61 6c 6c 20 64 61 74 | 61 20 65 6e 74 72 79 20 | all dat|a entry |
|00005230| 63 65 6c 6c 73 20 61 74 | 20 6f 6e 63 65 2e 20 20 |cells at| once. |
|00005240| 49 66 20 79 6f 75 20 68 | 69 74 20 74 68 69 73 20 |If you h|it this |
|00005250| 62 75 74 74 6f 6e 20 62 | 79 20 6d 69 73 74 61 6b |button b|y mistak|
|00005260| 65 20 6f 72 20 63 68 61 | 6e 67 65 20 79 6f 75 72 |e or cha|nge your|
|00005270| 20 6d 69 6e 64 2c 20 61 | 6e 64 20 68 61 76 65 6e | mind, a|nd haven|
|00005280| 27 74 20 68 69 74 20 74 | 68 65 20 72 65 74 75 72 |'t hit t|he retur|
|00005290| 6e 20 6b 65 79 20 61 20 | 73 65 63 6f 6e 64 20 74 |n key a |second t|
|000052a0| 69 6d 65 2c 20 79 6f 75 | 20 63 61 6e 20 72 65 6d |ime, you| can rem|
|000052b0| 6f 76 65 20 74 68 69 73 | 20 77 69 74 68 20 74 68 |ove this| with th|
|000052c0| 65 20 55 4e 44 4f 20 6f | 70 74 69 6f 6e 20 75 6e |e UNDO o|ption un|
|000052d0| 64 65 72 20 74 68 65 20 | 45 44 49 54 20 4d 45 4e |der the |EDIT MEN|
|000052e0| 55 2e 20 48 6f 77 65 76 | 65 72 2c 20 74 68 65 20 |U. Howev|er, the |
|000052f0| 6e 65 77 20 76 61 6c 75 | 65 20 69 6e 20 63 65 6c |new valu|e in cel|
|00005300| 6c 20 44 39 20 77 69 6c | 6c 20 6e 65 65 64 20 74 |l D9 wil|l need t|
|00005310| 6f 20 62 65 20 72 65 6d | 6f 76 65 64 20 62 79 20 |o be rem|oved by |
|00005320| 79 6f 75 2e 20 54 68 69 | 73 20 62 75 74 74 6f 6e |you. Thi|s button|
|00005330| 20 77 69 6c 6c 20 6e 6f | 74 20 63 6c 65 61 72 20 | will no|t clear |
|00005340| 6f 72 20 73 65 74 20 74 | 68 65 20 62 65 67 69 6e |or set t|he begin|
|00005350| 20 63 61 73 68 20 62 6f | 78 2e 20 45 6e 74 65 72 | cash bo|x. Enter|
|00005360| 69 6e 67 20 3d 22 22 20 | 77 69 6c 6c 20 73 65 74 |ing ="" |will set|
|00005370| 20 61 6c 6c 20 63 65 6c | 6c 73 20 42 4c 41 4e 4b | all cel|ls BLANK|
|00005380| 2e 20 54 68 61 74 20 70 | 72 6f 63 65 64 75 72 65 |. That p|rocedure|
|00005390| 20 69 73 20 6d 6f 73 74 | 20 68 61 6e 64 79 20 61 | is most| handy a|
|000053a0| 66 74 65 72 20 79 6f 75 | 20 6d 61 79 20 68 61 76 |fter you| may hav|
|000053b0| 65 20 74 65 73 74 65 64 | 20 61 6c 6c 20 74 68 65 |e tested| all the|
|000053c0| 20 65 78 69 73 74 69 6e | 67 20 66 6f 72 6d 75 6c | existin|g formul|
|000053d0| 61 73 20 6f 6e 20 74 68 | 65 20 4e 45 57 20 57 4f |as on th|e NEW WO|
|000053e0| 52 4b 53 48 45 45 54 21 | 0d 0d 62 29 20 42 45 47 |RKSHEET!|..b) BEG|
|000053f0| 49 4e 20 43 41 53 48 20 | 2d 20 54 68 69 73 20 62 |IN CASH |- This b|
|00005400| 75 74 74 6f 6e 20 61 6c | 6c 6f 77 73 20 79 6f 75 |utton al|lows you|
|00005410| 20 74 6f 20 70 72 65 73 | 65 74 20 68 6f 77 20 6d | to pres|et how m|
|00005420| 75 63 68 20 63 61 73 68 | 20 79 6f 75 20 77 69 6c |uch cash| you wil|
|00005430| 6c 20 62 65 20 73 74 61 | 72 74 69 6e 67 20 77 69 |l be sta|rting wi|
|00005440| 74 68 2e 20 20 59 6f 75 | 20 61 72 65 20 6e 6f 74 |th. You| are not|
|00005450| 20 72 65 71 75 69 72 65 | 64 20 74 6f 20 65 6e 74 | require|d to ent|
|00005460| 65 72 20 61 6e 20 61 6d | 6f 75 6e 74 2c 20 61 73 |er an am|ount, as|
|00005470| 20 7a 65 72 6f 20 69 73 | 20 61 6c 73 6f 20 61 63 | zero is| also ac|
|00005480| 63 65 70 74 61 62 6c 65 | 2e 20 54 68 69 73 20 63 |ceptable|. This c|
|00005490| 65 6c 6c 20 63 6f 75 6c | 64 20 61 6c 73 6f 20 62 |ell coul|d also b|
|000054a0| 65 20 75 73 65 64 20 74 | 6f 20 6c 69 6e 6b 20 74 |e used t|o link t|
|000054b0| 68 65 20 70 72 65 76 69 | 6f 75 73 20 79 65 61 72 |he previ|ous year|
|000054c0| 27 73 20 65 6e 64 69 6e | 67 20 63 61 72 72 79 20 |'s endin|g carry |
|000054d0| 61 6d 6f 75 6e 74 2e 0d | 0d 32 2e 20 45 61 63 68 |amount..|.2. Each|
|000054e0| 20 49 6e 63 6f 6d 65 20 | 26 20 45 78 70 65 6e 73 | Income |& Expens|
|000054f0| 65 20 72 6f 77 20 63 6f | 6e 74 61 69 6e 73 20 74 |e row co|ntains t|
|00005500| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 69 6e 64 |he follo|wing ind|
|00005510| 65 70 65 6e 64 65 6e 74 | 20 62 75 74 74 6f 6e 3a |ependent| button:|
|00005520| 0d 0d 52 45 50 45 41 54 | 20 2d 20 54 68 69 73 20 |..REPEAT| - This |
|00005530| 62 75 74 74 6f 6e 20 77 | 69 6c 6c 20 64 6f 20 74 |button w|ill do t|
|00005540| 68 65 20 73 61 6d 65 20 | 61 73 20 74 68 65 20 28 |he same |as the (|
|00005550| 53 45 54 20 41 4c 4c 20 | 43 45 4c 4c 20 54 4f 3f |SET ALL |CELL TO?|
|00005560| 3f 29 20 62 75 74 74 6f | 6e 20 6f 6e 20 61 20 6d |?) butto|n on a m|
|00005570| 75 63 68 20 73 6d 61 6c | 6c 65 72 20 73 63 61 6c |uch smal|ler scal|
|00005580| 65 2c 20 6f 6e 65 20 72 | 6f 77 20 61 74 20 61 20 |e, one r|ow at a |
|00005590| 74 69 6d 65 2e 20 49 66 | 20 79 6f 75 20 68 69 74 |time. If| you hit|
|000055a0| 20 74 68 69 73 20 62 75 | 74 74 6f 6e 20 62 79 20 | this bu|tton by |
|000055b0| 6d 69 73 74 61 6b 65 2c | 20 6f 72 20 63 68 61 6e |mistake,| or chan|
|000055c0| 67 65 20 79 6f 75 72 20 | 6d 69 6e 64 2c 20 61 6e |ge your |mind, an|
|000055d0| 64 20 68 61 76 65 6e 27 | 74 20 68 69 74 20 74 68 |d haven'|t hit th|
|000055e0| 65 20 72 65 74 75 72 6e | 20 6b 65 79 20 61 20 73 |e return| key a s|
|000055f0| 65 63 6f 6e 64 20 74 69 | 6d 65 2c 20 79 6f 75 20 |econd ti|me, you |
|00005600| 63 61 6e 20 72 65 6d 6f | 76 65 20 74 68 65 20 6e |can remo|ve the n|
|00005610| 65 77 20 76 61 6c 75 65 | 20 77 69 74 68 20 74 68 |ew value| with th|
|00005620| 65 20 55 4e 44 4f 20 6f | 70 74 69 6f 6e 20 75 6e |e UNDO o|ption un|
|00005630| 64 65 72 20 74 68 65 20 | 45 44 49 54 20 4d 45 4e |der the |EDIT MEN|
|00005640| 55 2e 20 20 44 6f 6e 27 | 74 20 66 6f 72 67 65 74 |U. Don'|t forget|
|00005650| 2c 20 79 6f 75 20 6d 75 | 73 74 20 70 65 72 73 6f |, you mu|st perso|
|00005660| 6e 61 6c 6c 79 20 72 65 | 6d 6f 76 65 20 74 68 65 |nally re|move the|
|00005670| 20 6e 65 77 20 76 61 6c | 75 65 20 66 72 6f 6d 20 | new val|ue from |
|00005680| 63 6f 6c 75 6d 6e 20 44 | 20 6f 66 20 74 68 65 20 |column D| of the |
|00005690| 63 75 72 72 65 6e 74 20 | 72 6f 77 2e 20 45 6e 74 |current |row. Ent|
|000056a0| 65 72 69 6e 67 20 3d 22 | 22 20 77 69 6c 6c 20 73 |ering ="|" will s|
|000056b0| 65 74 20 61 6c 6c 20 63 | 65 6c 6c 73 20 42 4c 41 |et all c|ells BLA|
|000056c0| 4e 4b 2e 0d 0d a5 20 43 | 6f 6c 75 6d 6e 20 44 20 |NK.... C|olumn D |
|000056d0| 2d 20 54 68 69 73 20 61 | 72 65 61 20 68 61 73 20 |- This a|rea has |
|000056e0| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 62 75 |the foll|owing bu|
|000056f0| 74 74 6f 6e 73 3a 0d 20 | 0d 31 2e 20 54 6f 67 67 |ttons:. |.1. Togg|
|00005700| 6c 65 20 62 75 74 74 6f | 6e 73 3a 20 28 6f 6e 65 |le butto|ns: (one|
|00005710| 20 62 75 74 74 6f 6e 20 | 69 73 20 6f 6e 20 74 6f | button |is on to|
|00005720| 70 20 6f 66 20 61 6e 6f | 74 68 65 72 20 62 75 74 |p of ano|ther but|
|00005730| 74 6f 6e 29 0d 0d 61 29 | 20 20 50 55 53 48 20 46 |ton)..a)| PUSH F|
|00005740| 4f 52 20 4e 41 4d 45 20 | 2d 20 54 68 69 73 20 62 |OR NAME |- This b|
|00005750| 75 74 74 6f 6e 20 77 69 | 6c 6c 20 64 75 70 6c 69 |utton wi|ll dupli|
|00005760| 63 61 74 65 20 77 68 61 | 74 65 76 65 72 20 6e 61 |cate wha|tever na|
|00005770| 6d 65 20 79 6f 75 20 65 | 6e 74 65 72 20 69 6e 20 |me you e|nter in |
|00005780| 74 68 65 20 69 6e 70 75 | 74 20 62 6f 78 20 61 63 |the inpu|t box ac|
|00005790| 72 6f 73 73 20 74 68 65 | 20 74 6f 70 20 6f 66 20 |ross the| top of |
|000057a0| 74 68 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |the spre|adsheet |
|000057b0| 69 6e 20 74 68 65 20 61 | 70 70 72 6f 70 72 69 61 |in the a|ppropria|
|000057c0| 74 65 20 62 6f 78 65 73 | 2e 20 49 20 74 68 6f 75 |te boxes|. I thou|
|000057d0| 67 68 74 20 74 68 69 73 | 20 77 6f 75 6c 64 20 70 |ght this| would p|
|000057e0| 65 72 73 6f 6e 61 6c 69 | 7a 65 20 79 6f 75 72 20 |ersonali|ze your |
|000057f0| 62 75 64 67 65 74 2e 0d | 0d 62 29 20 50 55 53 48 |budget..|.b) PUSH|
|00005800| 20 46 4f 52 20 44 41 54 | 45 20 2d 20 54 68 69 73 | FOR DAT|E - This|
|00005810| 20 62 75 74 74 6f 6e 2c | 20 77 68 65 6e 20 67 69 | button,| when gi|
|00005820| 76 65 6e 20 74 68 65 20 | 63 6f 72 72 65 63 74 20 |ven the |correct |
|00005830| 69 6e 70 75 74 2c 20 77 | 69 6c 6c 20 65 6e 74 65 |input, w|ill ente|
|00005840| 72 20 74 68 65 20 66 69 | 72 73 74 20 62 75 64 67 |r the fi|rst budg|
|00005850| 65 74 20 73 74 61 72 74 | 69 6e 67 20 64 61 74 65 |et start|ing date|
|00005860| 2c 20 61 6e 64 20 74 68 | 65 6e 20 67 65 6e 65 72 |, and th|en gener|
|00005870| 61 74 65 20 73 75 63 63 | 65 73 73 69 76 65 20 64 |ate succ|essive d|
|00005880| 61 74 65 73 20 66 72 6f | 6d 20 74 68 61 74 20 70 |ates fro|m that p|
|00005890| 6f 69 6e 74 2c 20 61 63 | 72 6f 73 73 20 74 68 65 |oint, ac|ross the|
|000058a0| 20 4e 45 57 20 42 55 44 | 47 45 54 20 57 4f 52 4b | NEW BUD|GET WORK|
|000058b0| 53 48 45 45 54 2e 20 54 | 6f 20 6d 61 6b 65 20 74 |SHEET. T|o make t|
|000058c0| 68 69 73 20 77 6f 72 6b | 2c 20 79 6f 75 20 77 69 |his work|, you wi|
|000058d0| 6c 6c 20 6e 65 65 64 20 | 74 6f 20 65 6e 74 65 72 |ll need |to enter|
|000058e0| 20 77 68 61 74 20 77 61 | 73 2f 6f 72 20 77 6f 75 | what wa|s/or wou|
|000058f0| 6c 64 20 68 61 76 65 20 | 62 65 65 6e 2c 20 79 6f |ld have |been, yo|
|00005900| 75 72 20 66 69 72 73 74 | 20 70 61 79 20 64 61 74 |ur first| pay dat|
|00005910| 65 20 6f 66 20 74 68 65 | 20 63 75 72 72 65 6e 74 |e of the| current|
|00005920| 20 79 65 61 72 2e 20 54 | 68 69 73 20 73 74 69 6c | year. T|his stil|
|00005930| 6c 20 61 70 70 6c 69 65 | 73 20 65 76 65 6e 20 69 |l applie|s even i|
|00005940| 66 20 79 6f 75 20 73 74 | 61 72 74 20 74 68 65 20 |f you st|art the |
|00005950| 62 75 64 67 65 74 20 61 | 74 20 73 6f 6d 65 20 74 |budget a|t some t|
|00005960| 69 6d 65 20 62 65 79 6f | 6e 64 20 74 68 65 20 66 |ime beyo|nd the f|
|00005970| 69 72 73 74 20 62 69 77 | 65 65 6b 20 6f 66 20 74 |irst biw|eek of t|
|00005980| 68 65 20 63 75 72 72 65 | 6e 74 20 79 65 61 72 2e |he curre|nt year.|
|00005990| 20 59 6f 75 20 77 69 6c | 6c 20 6a 75 73 74 20 6e | You wil|l just n|
|000059a0| 6f 74 20 65 6e 74 65 72 | 20 64 61 74 61 20 69 6e |ot enter| data in|
|000059b0| 20 74 68 65 20 62 69 77 | 65 65 6b 73 20 74 68 61 | the biw|eeks tha|
|000059c0| 74 20 61 72 65 20 6e 6f | 74 20 63 75 72 72 65 6e |t are no|t curren|
|000059d0| 74 20 66 6f 72 20 79 6f | 75 3b 20 74 68 61 74 20 |t for yo|u; that |
|000059e0| 69 73 2c 20 75 6e 6c 65 | 73 73 20 79 6f 75 20 68 |is, unle|ss you h|
|000059f0| 61 76 65 20 74 68 65 20 | 70 72 69 6f 72 20 72 65 |ave the |prior re|
|00005a00| 63 6f 72 64 20 6b 65 65 | 70 69 6e 67 2e 20 53 6f |cord kee|ping. So|
|00005a10| 2c 20 73 74 61 72 74 20 | 79 6f 75 72 20 62 75 64 |, start |your bud|
|00005a20| 67 65 74 20 66 72 6f 6d | 20 74 68 65 20 66 69 72 |get from| the fir|
|00005a30| 73 74 20 64 61 74 65 20 | 74 68 61 74 20 69 73 20 |st date |that is |
|00005a40| 61 70 70 6c 69 63 61 62 | 6c 65 2c 20 6f 72 20 61 |applicab|le, or a|
|00005a50| 20 70 72 65 76 69 6f 75 | 73 20 62 69 77 65 65 6b | previou|s biweek|
|00005a60| 2c 20 69 66 20 79 6f 75 | 20 68 61 76 65 20 74 68 |, if you| have th|
|00005a70| 61 74 20 64 61 74 61 20 | 61 6e 64 20 77 69 73 68 |at data |and wish|
|00005a80| 20 74 6f 20 65 6e 74 65 | 72 20 74 68 61 74 20 69 | to ente|r that i|
|00005a90| 6e 66 6f 72 6d 61 74 69 | 6f 6e 20 66 6f 72 20 61 |nformati|on for a|
|00005aa0| 20 70 65 72 6d 61 6e 65 | 6e 74 20 72 65 63 6f 72 | permane|nt recor|
|00005ab0| 64 2e 0d 20 0d a5 20 43 | 6f 6c 75 6d 6e 73 20 44 |d.. .. C|olumns D|
|00005ac0| 20 74 68 72 6f 75 67 68 | 20 41 44 20 2d 20 54 68 | through| AD - Th|
|00005ad0| 69 73 20 61 72 65 61 20 | 68 61 73 20 74 68 65 20 |is area |has the |
|00005ae0| 66 6f 6c 6c 6f 77 69 6e | 67 20 62 75 74 74 6f 6e |followin|g button|
|00005af0| 3a 0d 20 0d 47 4f 54 4f | 20 53 55 4d 4d 41 52 59 |:. .GOTO| SUMMARY|
|00005b00| 20 2d 20 54 68 69 73 20 | 62 75 74 74 6f 6e 20 77 | - This |button w|
|00005b10| 69 6c 6c 20 74 61 6b 65 | 20 79 6f 75 20 74 6f 20 |ill take| you to |
|00005b20| 74 68 65 20 73 75 6d 6d | 61 72 79 20 61 72 65 61 |the summ|ary area|
|00005b30| 2e 20 46 72 6f 6d 20 68 | 65 72 65 2c 20 61 6c 6c |. From h|ere, all|
|00005b40| 20 74 68 65 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e | the inf|ormation|
|00005b50| 20 79 6f 75 20 68 61 76 | 65 20 6f 72 20 77 69 6c | you hav|e or wil|
|00005b60| 6c 20 65 6e 74 65 72 20 | 6c 61 74 65 72 20 69 73 |l enter |later is|
|00005b70| 20 74 6f 74 61 6c 65 64 | 2e 20 57 68 65 6e 20 62 | totaled|. When b|
|00005b80| 75 64 67 65 74 69 6e 67 | 20 61 20 63 65 72 74 61 |udgeting| a certa|
|00005b90| 69 6e 20 61 6d 6f 75 6e | 74 2c 20 74 68 69 73 20 |in amoun|t, this |
|00005ba0| 77 69 6c 6c 20 63 6f 6d | 65 20 69 6e 20 68 61 6e |will com|e in han|
|00005bb0| 64 79 20 74 6f 20 64 65 | 74 65 72 6d 69 6e 65 20 |dy to de|termine |
|00005bc0| 69 66 20 79 6f 75 20 68 | 61 76 65 20 6d 65 74 20 |if you h|ave met |
|00005bd0| 74 68 61 74 20 67 6f 61 | 6c 20 6f 72 20 6e 65 65 |that goa|l or nee|
|00005be0| 64 20 74 6f 20 64 65 63 | 72 65 61 73 65 2f 69 6e |d to dec|rease/in|
|00005bf0| 63 72 65 61 73 65 20 69 | 74 2e 20 54 68 65 20 4c |crease i|t. The L|
|00005c00| 69 6e 6b 69 6e 67 20 61 | 72 65 61 20 68 61 73 20 |inking a|rea has |
|00005c10| 6d 6f 6e 74 68 6c 79 20 | 74 6f 74 61 6c 73 2e 0d |monthly |totals..|
|00005c20| 0d a5 20 43 6f 6c 75 6d | 6e 73 20 44 20 74 68 72 |.. Colum|ns D thr|
|00005c30| 6f 75 67 68 20 41 43 20 | 2d 20 54 68 69 73 20 61 |ough AC |- This a|
|00005c40| 72 65 61 20 63 6f 6e 74 | 61 69 6e 73 20 79 6f 75 |rea cont|ains you|
|00005c50| 72 20 74 77 65 6e 74 79 | 2d 73 69 78 20 28 32 36 |r twenty|-six (26|
|00005c60| 29 20 62 69 77 65 65 6b | 73 20 6f 66 20 64 61 74 |) biweek|s of dat|
|00005c70| 61 20 65 6e 74 72 79 2e | 20 48 4f 57 45 56 45 52 |a entry.| HOWEVER|
|00005c80| 2c 20 62 61 73 65 64 20 | 75 70 6f 6e 20 74 68 65 |, based |upon the|
|00005c90| 20 73 74 61 72 74 69 6e | 67 20 64 61 74 65 20 74 | startin|g date t|
|00005ca0| 68 61 74 20 79 6f 75 20 | 65 6e 74 65 72 65 64 20 |hat you |entered |
|00005cb0| 69 6e 20 43 6f 6c 75 6d | 6e 20 44 20 61 6e 64 2f |in Colum|n D and/|
|00005cc0| 6f 72 20 61 20 6c 65 61 | 70 20 79 65 61 72 2c 20 |or a lea|p year, |
|00005cd0| 61 20 74 77 65 6e 74 79 | 2d 73 65 76 65 6e 74 68 |a twenty|-seventh|
|00005ce0| 20 28 32 37 74 68 29 20 | 62 69 77 65 65 6b 20 6d | (27th) |biweek m|
|00005cf0| 61 79 20 62 65 20 6e 65 | 65 64 65 64 21 20 43 6f |ay be ne|eded! Co|
|00005d00| 6c 75 6d 6e 20 41 44 20 | 63 6f 6e 74 61 69 6e 73 |lumn AD |contains|
|00005d10| 20 74 68 65 20 74 77 65 | 6e 74 79 2d 73 65 76 65 | the twe|nty-seve|
|00005d20| 6e 74 68 20 28 32 37 74 | 68 29 20 62 69 77 65 65 |nth (27t|h) biwee|
|00005d30| 6b 2e 20 20 54 68 69 73 | 20 62 69 77 65 65 6b 20 |k. This| biweek |
|00005d40| 64 65 73 65 72 76 65 73 | 20 61 20 73 70 65 63 69 |deserves| a speci|
|00005d50| 61 6c 20 6e 6f 74 65 2e | 20 20 41 20 66 6f 72 6d |al note.| A form|
|00005d60| 75 6c 61 20 76 65 72 69 | 66 69 65 73 20 69 66 20 |ula veri|fies if |
|00005d70| 74 68 65 20 62 69 77 65 | 65 6b 20 69 73 20 73 74 |the biwe|ek is st|
|00005d80| 69 6c 6c 20 69 6e 20 74 | 68 65 20 63 75 72 72 65 |ill in t|he curre|
|00005d90| 6e 74 20 79 65 61 72 2e | 20 49 66 20 69 74 20 69 |nt year.| If it i|
|00005da0| 73 2c 20 74 68 65 6e 20 | 74 68 65 20 69 6e 63 6f |s, then |the inco|
|00005db0| 6d 65 2f 65 78 70 65 6e | 73 65 73 20 61 72 65 20 |me/expen|ses are |
|00005dc0| 61 64 64 65 64 20 69 6e | 20 74 68 61 74 20 63 6f |added in| that co|
|00005dd0| 6c 75 6d 6e 2c 20 61 6e | 64 20 61 6c 73 6f 20 69 |lumn, an|d also i|
|00005de0| 6e 74 6f 20 74 68 65 20 | 73 75 6d 6d 61 72 79 20 |nto the |summary |
|00005df0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 2e 20 20 49 66 |informat|ion. If|
|00005e00| 20 74 68 65 20 62 69 77 | 65 65 6b 20 69 73 20 69 | the biw|eek is i|
|00005e10| 6e 20 74 68 65 20 4e 45 | 58 54 20 59 45 41 52 2c |n the NE|XT YEAR,|
|00005e20| 20 74 68 65 6e 20 74 68 | 65 20 66 6f 72 6d 75 6c | then th|e formul|
|00005e30| 61 20 77 69 6c 6c 20 64 | 69 73 72 65 67 61 72 64 |a will d|isregard|
|00005e40| 20 74 68 61 74 20 62 69 | 77 65 65 6b 20 61 6e 64 | that bi|week and|
|00005e50| 20 6e 6f 74 20 61 64 64 | 20 74 68 65 20 61 6d 6f | not add| the amo|
|00005e60| 75 6e 74 73 20 64 6f 77 | 6e 20 6f 72 20 69 6e 74 |unts dow|n or int|
|00005e70| 6f 20 74 68 65 20 73 75 | 6d 6d 61 72 79 20 74 6f |o the su|mmary to|
|00005e80| 74 61 6c 73 2e 20 20 54 | 48 41 54 20 49 53 20 57 |tals. T|HAT IS W|
|00005e90| 48 59 20 59 4f 55 20 4d | 55 53 54 20 45 4e 54 45 |HY YOU M|UST ENTE|
|00005ea0| 52 20 59 4f 55 52 20 53 | 54 41 52 54 49 4e 47 20 |R YOUR S|TARTING |
|00005eb0| 44 41 54 45 20 43 4f 52 | 52 45 43 54 4c 59 2c 20 |DATE COR|RECTLY, |
|00005ec0| 61 73 20 74 68 65 20 66 | 69 72 73 74 20 62 69 77 |as the f|irst biw|
|00005ed0| 65 65 6b 20 69 6e 20 74 | 68 65 20 79 65 61 72 2e |eek in t|he year.|
|00005ee0| 20 49 66 20 79 6f 75 20 | 74 68 6f 75 67 68 74 20 | If you |thought |
|00005ef0| 61 62 6f 75 74 20 74 68 | 65 20 52 45 50 45 41 54 |about th|e REPEAT|
|00005f00| 20 6b 65 79 20 64 6f 6e | 27 74 20 77 6f 72 72 79 | key don|'t worry|
|00005f10| 2e 20 52 65 6d 65 6d 62 | 65 72 2c 20 65 76 65 6e |. Rememb|er, even|
|00005f20| 20 69 66 20 74 68 65 72 | 65 20 77 61 73 2f 6f 72 | if ther|e was/or|
|00005f30| 20 77 69 6c 6c 20 62 65 | 20 61 6e 20 61 6d 6f 75 | will be| an amou|
|00005f40| 6e 74 20 69 6e 20 74 68 | 65 20 74 77 65 6e 74 79 |nt in th|e twenty|
|00005f50| 2d 73 65 76 65 6e 74 68 | 20 28 32 37 74 68 29 20 |-seventh| (27th) |
|00005f60| 62 69 77 65 65 6b 2c 20 | 74 68 65 20 44 41 54 45 |biweek, |the DATE|
|00005f70| 53 20 68 61 76 65 20 74 | 6f 20 6d 61 74 63 68 20 |S have t|o match |
|00005f80| 66 6f 72 20 74 68 65 20 | 66 69 67 75 72 65 73 20 |for the |figures |
|00005f90| 74 6f 20 61 63 74 75 61 | 6c 6c 79 20 63 6f 75 6e |to actua|lly coun|
|00005fa0| 74 20 28 62 65 20 61 64 | 64 65 64 29 2e 20 20 49 |t (be ad|ded). I|
|00005fb0| 66 20 49 20 63 6f 75 6c | 64 20 68 61 76 65 20 64 |f I coul|d have d|
|00005fc0| 65 76 69 73 65 64 20 61 | 20 77 61 79 20 74 6f 20 |evised a| way to |
|00005fd0| 64 6f 20 74 68 69 73 20 | 66 6f 72 20 61 6c 6c 20 |do this |for all |
|00005fe0| 62 69 77 65 65 6b 73 2c | 20 49 20 77 6f 75 6c 64 |biweeks,| I would|
|00005ff0| 20 68 61 76 65 2c 20 62 | 75 74 20 61 6c 61 73 2c | have, b|ut alas,|
|00006000| 20 66 6f 72 6d 75 6c 61 | 20 6c 65 6e 67 74 68 20 | formula| length |
|00006010| 77 61 73 20 74 68 65 20 | 6b 69 6c 6c 65 72 20 69 |was the |killer i|
|00006020| 6e 20 74 68 61 74 20 72 | 65 67 61 72 64 2e 20 54 |n that r|egard. T|
|00006030| 48 41 54 20 49 53 20 57 | 48 59 20 59 4f 55 20 4d |HAT IS W|HY YOU M|
|00006040| 55 53 54 20 45 4e 54 45 | 52 20 59 4f 55 52 20 53 |UST ENTE|R YOUR S|
|00006050| 54 41 52 54 49 4e 47 20 | 44 41 54 45 20 43 4f 52 |TARTING |DATE COR|
|00006060| 52 45 43 54 4c 59 2e 0d | 09 09 09 09 09 09 09 0d |RECTLY..|........|
|00006070| a5 20 43 6f 6c 75 6d 6e | 20 45 20 2d 20 54 68 69 |. Column| E - Thi|
|00006080| 73 20 61 72 65 61 20 68 | 61 73 20 74 68 65 20 66 |s area h|as the f|
|00006090| 6f 6c 6c 6f 77 69 6e 67 | 20 62 75 74 74 6f 6e 73 |ollowing| buttons|
|000060a0| 3a 0d 20 0d 31 2e 20 52 | 45 41 44 20 2d 20 54 68 |:. .1. R|EAD - Th|
|000060b0| 69 73 20 62 75 74 74 6f | 6e 20 67 65 6e 65 72 61 |is butto|n genera|
|000060c0| 74 65 73 20 6f 6e 20 73 | 63 72 65 65 6e 20 68 65 |tes on s|creen he|
|000060d0| 6c 70 20 77 69 74 68 20 | 70 69 63 74 75 72 65 73 |lp with |pictures|
|000060e0| 20 6f 66 20 74 68 65 20 | 74 6f 67 67 6c 65 20 62 | of the |toggle b|
|000060f0| 75 74 74 6f 6e 73 2e 0d | 0d 32 2e 20 54 49 4d 45 |uttons..|.2. TIME|
|00006100| 20 2d 20 59 6f 75 20 77 | 69 6c 6c 20 6e 6f 74 69 | - You w|ill noti|
|00006110| 63 65 20 74 77 6f 20 74 | 79 70 65 73 20 6f 66 20 |ce two t|ypes of |
|00006120| 74 69 6d 65 20 62 75 74 | 74 6f 6e 73 2e 20 54 68 |time but|tons. Th|
|00006130| 65 20 74 6f 70 20 72 6f | 77 20 6f 66 20 74 69 6d |e top ro|w of tim|
|00006140| 65 20 62 75 74 74 6f 6e | 73 20 74 68 61 74 20 73 |e button|s that s|
|00006150| 74 61 72 74 20 61 74 20 | 43 6f 6c 75 6d 6e 20 45 |tart at |Column E|
|00006160| 20 61 6e 64 20 73 6b 69 | 70 20 74 6f 20 65 76 65 | and ski|p to eve|
|00006170| 72 79 20 6f 74 68 65 72 | 20 63 6f 6c 75 6d 6e 20 |ry other| column |
|00006180| 77 69 6c 6c 20 70 72 6f | 64 75 63 65 20 74 68 65 |will pro|duce the|
|00006190| 20 74 69 6d 65 20 61 6e | 64 20 64 61 74 65 20 61 | time an|d date a|
|000061a0| 63 72 6f 73 73 20 74 68 | 65 20 74 6f 70 20 6f 66 |cross th|e top of|
|000061b0| 20 74 68 65 20 77 6f 72 | 6b 73 68 65 65 74 2e 20 | the wor|ksheet. |
|000061c0| 54 68 65 20 73 65 63 6f | 6e 64 20 67 72 6f 75 70 |The seco|nd group|
|000061d0| 69 6e 67 20 6f 66 20 74 | 69 6d 65 20 62 75 74 74 |ing of t|ime butt|
|000061e0| 6f 6e 73 20 74 68 61 74 | 20 73 74 61 72 74 20 61 |ons that| start a|
|000061f0| 74 20 43 6f 6c 75 6d 6e | 20 45 2c 20 28 72 6f 77 |t Column| E, (row|
|00006200| 20 74 77 65 6e 74 79 2d | 74 68 72 65 65 20 28 32 | twenty-|three (2|
|00006210| 33 29 29 2c 20 67 65 6e | 65 72 61 74 65 20 74 68 |3)), gen|erate th|
|00006220| 65 20 74 69 6d 65 20 6f | 6e 6c 79 2c 20 74 68 61 |e time o|nly, tha|
|00006230| 74 20 73 70 69 72 61 6c | 73 20 64 6f 77 6e 20 74 |t spiral|s down t|
|00006240| 68 65 20 77 6f 72 6b 73 | 68 65 65 74 2e 20 20 49 |he works|heet. I|
|00006250| 20 73 65 70 61 72 61 74 | 65 64 20 74 68 65 20 74 | separat|ed the t|
|00006260| 77 6f 20 74 69 6d 65 20 | 61 72 65 61 73 20 73 6f |wo time |areas so|
|00006270| 20 74 68 61 74 20 74 68 | 65 72 65 20 69 73 20 61 | that th|ere is a|
|00006280| 20 72 65 66 65 72 65 6e | 63 65 20 66 6f 72 20 77 | referen|ce for w|
|00006290| 68 65 6e 20 74 68 61 74 | 20 70 61 72 74 20 6f 66 |hen that| part of|
|000062a0| 20 74 68 65 20 73 70 72 | 65 61 64 73 68 65 65 74 | the spr|eadsheet|
|000062b0| 20 69 73 20 61 63 63 65 | 73 73 65 64 2e 20 20 54 | is acce|ssed. T|
|000062c0| 68 65 72 65 20 61 72 65 | 20 6f 74 68 65 72 20 74 |here are| other t|
|000062d0| 69 6d 65 20 73 65 70 61 | 72 61 74 69 6f 6e 73 20 |ime sepa|rations |
|000062e0| 74 68 72 6f 75 67 68 6f | 75 74 20 74 68 65 20 73 |througho|ut the s|
|000062f0| 70 72 65 61 64 73 68 65 | 65 74 2e 0d 0d a5 20 43 |preadshe|et.... C|
|00006300| 6f 6c 75 6d 6e 73 20 41 | 47 20 74 68 72 6f 75 67 |olumns A|G throug|
|00006310| 68 20 41 4d 20 2d 20 54 | 68 69 73 20 61 72 65 61 |h AM - T|his area|
|00006320| 20 63 6f 6e 74 61 69 6e | 73 20 61 6c 6c 20 74 68 | contain|s all th|
|00006330| 65 20 73 75 6d 6d 61 72 | 79 20 69 6e 66 6f 72 6d |e summar|y inform|
|00006340| 61 74 69 6f 6e 20 6f 66 | 20 74 68 65 20 64 61 74 |ation of| the dat|
|00006350| 61 20 65 6e 74 72 79 20 | 61 72 65 61 2e 20 20 49 |a entry |area. I|
|00006360| 6e 20 6f 74 68 65 72 20 | 77 6f 72 64 73 2c 20 74 |n other |words, t|
|00006370| 68 65 20 74 6f 74 61 6c | 20 65 78 70 65 6e 73 65 |he total| expense|
|00006380| 73 20 61 6e 64 20 69 6e | 63 6f 6d 65 20 66 6f 72 |s and in|come for|
|00006390| 20 74 68 65 20 65 6e 74 | 69 72 65 20 79 65 61 72 | the ent|ire year|
|000063a0| 20 65 6e 64 20 75 70 20 | 68 65 72 65 20 69 6e 20 | end up |here in |
|000063b0| 43 6f 6c 75 6d 6e 20 41 | 4a 2e 20 20 43 6f 6c 75 |Column A|J. Colu|
|000063c0| 6d 6e 20 41 4c 20 73 68 | 6f 77 73 20 74 68 65 20 |mn AL sh|ows the |
|000063d0| 70 65 72 63 65 6e 74 61 | 67 65 73 20 6f 66 20 69 |percenta|ges of i|
|000063e0| 6e 63 6f 6d 65 20 66 6f | 72 20 65 61 63 68 20 69 |ncome fo|r each i|
|000063f0| 74 65 6d 2e 20 46 6f 72 | 20 65 61 63 68 20 43 61 |tem. For| each Ca|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.